Qlikview Course Content

INTRODUCTION

  • Target Audience
  • What You Will Learn in this Course
  • Course Logistics
  • Notes

QLIKVIEW ENVIRONMENT

  • Qlikview Desktop

QLIKVIEW DEVELOPMENT METHODOLOGY

  • Import/Export Sheet and Document Layouts as XML
  • Qlik Wholesale Trade (QWT) Project Plan
  • Project Plan Review
  • SAFE Methodology

DEPLOYMENT

  • Qlikview Standalone
  • Qlikview Server
  • Qlikview Publisher

INTRODUCTION TO DATA AND SCRIPTING

  • Relational Databases
  • Other Data Structures
  • Comparing Database Structures to QlikView Data Structures
  • Data Structures in QlikView
  • Data Source Files
  • The QWT Primary Data Source
  • The QWT Secondary Data Files
  • Introduction to Scripting

BASIC SCRIPT SYNTAX

  • Syntax

LOADING DATA FROM THE DATABASE

  • Script Generation
  • Comments in the Script
  • Script Debugging

STRUCTURING THE SCRIPT

  • Creating Tabs in the Script

BASIC DATA MODEL AND TABLE VIEWER

  • The Table Viewer
  • The System Table
  • Document Properties: Tables page

BASIC DATA TRANSFORMATION

  • Load Statement
  • Renaming a Field
  • Script Expressions
  • Loading an XML File
  • Renaming Fields Using the Qualify Statement
  • Key Fields
  • Example Predicament
  • How Does this Affect You?
  • Loading a Field into a Table Multiple Times
  • Using a Record Counter on Key Fields
  • Is it Correct?

ADDING TEXT DATA

  • Employees
  • Offices
  • Script generation using the File Wizard

GENERATING DATA IN THE QLIKVIEW SCRIPT

  • Resident Load
  • Using Orders to determine Sales Person.
  • Include
  • Time Functions: Creating a Calendar
  • Getting the Highest and Lowest Date from the Orders Table
  • Autogenerate tables
  • Creating Variables in the Script
  • The Master Calendar

SCRIPTING CONSIDERATIONS

  • Synthetic Key Tables
  • Circular References
  • Causes of Circular References
  • Check the Numbers

QLIKVIEW DATA (QVD) FILES

  • QVD File Format
  • Use of QVD Files
  • Creating QVD Files
  • Manual Creation of a QVD File in the Script
  • Automatic Creation of a QVD File in the Script
  • QVD File Script Functions

REPORTING BUGS IN QLIKVIEW ADDITIONAL INFORMATION

  • Reference Materials
  • Data types in QlikView 137

LAYOUT BASICS FOR DEVELOPERS

  • User Friendly Design
  • Natural Human Behavior
  • Chart and Object Choices in QlikView
  • Import/Export Sheet and Document Layouts
  • APPENDIX: The Completed Script
  • QLIKVIEW_Developer_II

INTRODUCTION

  • Installing the Course Materials
  • Program versions
  • Text formats

DEVELOPER TOOLS

  • Troubleshooting
  • The Debugger

MAPPING TABLES

  • Mapping Quarters to the Orders table
  • Month Year
  • Cleaning up the table structure

LOADING BUDGET DATA

  • Reading Cross Tables

ADVANCED SCRIPTING

  • Condition on a field in a table
  • Aggregating Data
  • Joining tables
  • Concatenation
  • Preceding Load on Preceding Load

ADVANCED CALCULATIONS IN SHEET OBJECTS

  • Set Analysis
  • Dollar-Sign Expansion
  • AGGR Function

SCRIPTING AND DATA MODELING CHALLENGES

  • Link Tables and Concatenated Tables
  • Calculating net change within a field
  • Functions In Date, Data & Date Is lands
  • Aggr()
  • Class()
  • Dynamic Aggregation
  • Interval Match

DATA MODEL OPTIMIZATION

  • Performance Tuning
  • Best Practices for Qlikview File Optimization
  • Creating Incremental Loads

DATA MODEL OPTIMIZATION

  • Performance Tuning
  • Best Practices for Qlikview File Optimization
  • Creating Incremental Loads

DAILY AND TRANSACTION BALANCES

  • Overview
  • Example: Balances at Specific Dates
  • Example: Balances for Transactions (in/out)