QlikView Developer

Knowledge of the data model, creation of the proper data connections and scripting fundamentals are critical to creating QlikView applications that provide your organization with powerful business discovery tools. QlikView Developer provides you with an opportunity to learn by doing through a series of lectures and hands-on exercises focused on developing QlikView applications. Beginning with the QlikView environment and covering topics such as data modeling, synthetic keys and how to use the script editor, the QlikView Developer Essentials training course will prepare you to take your QlikView applications to the next level. The course concludes with a business case where you can practice your skills in building a QlikView application from the beginning using identified key performance indicators.

QlikView Developer - Advanced training course discusses advanced technical concepts including: applying expressions and functions, writing data load script, and data modeling strategies. It provides hands-on examples and demonstrates how these concepts can be applied to various business cases.

By attending QlikView Developer - Essentials workshop, attendees will learn to:

  • Create a data model in QlikView
  • Build a QlikView application
  • Resolve data structure issues
  • Access the Debugger
  • Define the advanced uses of the script editor
  • Use Transformative Functions in the script
  • Discuss Synthetic Keys

By attending QlikView Developer - Advanced workshop, attendees will learn:

  • Implement front-end solutions with advanced Qlik expressions and calculations.
  • Perform advanced set analysis operations, using advanced search expressions and element functions.
  • Perform comparative analysis using alternate states.
  • Use advanced Qlik functions and visualizations to perform Pareto (ABC), Basket, and Monte Carlo analyses.
  • Explain inter-record functions and manual accumulations.
  • Apply clustering and classification techniques to perform sales analysis
  • Use advanced Qlik scripting techniques to resolve data load issues.
  • Use loops and nested loops to load and analyze multiple files.
  • Apply multiple Load prefixes in various analysis case examples.
  • Transform the data model by applying subroutines to allow script reusability.
  • Create multiple QVD layers.
  • Optimize the data load process by applying incremental loads.
  • Explain and apply debug processes.
  • Use system error variables for debugging purposes.
  • Discuss advanced technical concepts and solutions in real life scenarios.

For QlikView Developer - Essentials

  • Attend Qlikview Designer course or possess equivalent knowledge
  • Attend Understanding Data Principles course or possess equivalent knowledge

For QlikView Developer - Advanced

  • Fundamental knowledge of the Qlik products (QlikView or Qlik Sense) and their related concepts.
  • Basic understanding of the Qlik script, Qlik expressions, and functions.
  • Attend the business analyst and/or data architect core courses.
  • Proficient with building applications, creating dashboards, and performing basic ETL transformations using the data load script.
  • At least six months experience working with Qlik as a business analyst or data architect

  • Business Analysts
  • Data Architects


QlikView Developer - Essentials
(Duration : 3 Days)


Qlikview Development Methodology



  • QlikView Desktop, Server and Publisher

Connect, select and load

  • QlikView’s QVD File and format
  • Comparing Database Structures to QlikView Data
  • Structures
  • Data Structures in QlikView
  • QlikView Data Modeling
  • Introduction to Scripting
  • The QWT Project Data, Primary & Secondary Data Source

Loading Data From The Database

  • Script Generation
  • Comments in the Script
  • The Create Select Statement Dialog
  • Creating Tabs in the Script
  • Script Debugging
  • The Script Execution Log File

Synthetic Keys


Basic Data Model And Table Viewer


Adding Text Data

  • The File Wizard
  • Your Excel Files
  • Script generation using the File Wizard

Basic Data Transformation

  • Load Statement
  • Renaming a Field
  • Script Expressions
  • Loading an XML File
  • The Qualify Statement, Key Fields, Count and Sum

Generating Data In The Qlikview Script

  • Resident Load
  • The Where Exists Clause

Scripting Considerations

  • More about Synthetic Keys
  • Synthetic Key Tables
  • Composite Keys
  • Circular References
  • Loosely Coupled Tables
  • Eliminating Circular Reference

Master Calendar

  • Date and Time
  • The Master Calendar
  • Using Flags
  • Data & Date Islands

Mapping Tables

  • Mapping Tables
  • Cleaning up the Table Structure
  • Preceding Load on Preceding Load

Data Model Optimization

  • How to Create QlikView Data Models
  • Joining tables
  • Concatenation
  • From Snow Flake to Star Scheme
  • Merged Facts Table
  • Aggregating Data

Scripting And Data Modeling Challenges

  • Link Tables and Concatenated Tables
  • Calculating Net Change within a Field
  • Dynamic Aggregation

Loading Budget Data

  • Cross Tables and Input field

Advanced Calculations In Sheet Objects

  • Dimension Limits
  • Perform comparative analysis using Alternate
  • States
  • Set Analysis
  • Dollar-Sign Expansion & Aggr Function

Meta Data

  • Tags, Comments & Renaming
  • Null functions
  • HidePrefix & HideSuffix

Qlikview Data (Qvd) Files

  • QVD File Format and its use
  • Creating QVD Files
  • Store Statement
  • Manual Creation of a QVD File in the Script

Performance Optimization

  • Performance Tuning
  • Best Practices for QlikView File Optimization

Qlikview Security

  • Access control
  • Access levels
  • Access control database
  • Inherited access restrictions
  • Hidden script
  • Adding Section Access
  • Access Control for Certain Commands
  • Further access control
  • Unattended Command Line Reload Considerations
  • Access restrictions on selected field values
  • Field value limitation in Section Access
QlikView Developer - Advanced
(Duration : 3 Days)


Using Qlikview

  • Starting QlikView
  • Basic Layout and Navigation

Sheets And Sheet Objects

  • Sheet Basics
  • Sheet Objects

Loading Data Into Qlikview

  • Script editing
  • Edit Script Toolbar
  • Edit Script Menu Commands
  • Statements Area

Creating The Script

  • Script generation
  • Creating a connection to the database
  • Reading tables into QlikView

Scripting Considerations And Data Modeling

  • Reading the QWT MDB
  • Synthetic key tables
  • Circular references
  • Causes of circular references
  • Loosely Coupled Tables

Loading An Xml File

  • Loading a text file in XML Format
  • Renaming fields using the Qualify statement

Generating Data In The Qlikview Script

  • Resident Load
  • Inline tables
  • Auto generate tables

Mapping Tables

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

Qlikview Data (Qvd) Files


Qlikview Securities


Advanced Set Analyses


Comparative Analyses


Advanced calculations


Advanced transformations in script


Incremental loads and QVDs


Debugging and troubleshooting

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.