QlikView is a business intelligence and data visualization platform developed by Qlik that uses an associative in-memory data model to enable interactive analysis across multiple data sources. Unlike query-based BI tools, QlikView loads all data into RAM and maintains dynamic associations between every field, allowing users to explore data freely without predefined drill paths. Now at version 12.90 (supported through October 2026), QlikView's dual scripting capability—combining a powerful ETL scripting language with an expression-based visualization layer—makes it uniquely suited for rapid, self-service analytics where users can uncover hidden insights through ad-hoc selection and exploration.
What This Cheat Sheet Covers
This topic spans 26 focused tables and 235 indexed concepts. Below is a complete table-by-table outline of this topic, spanning foundational concepts through advanced details.
Table 1: Load Script Prefixes and Data Loading
| Prefix | Example | Description |
|---|---|---|
LOAD CustomerID, Sales FROM data.csv; | • Loads data from files or inline definitions • the fundamental data loading statement in QlikView script | |
LOAD * RESIDENT Orders WHERE Year=2024; | • Loads data from an already-loaded in-memory table • used for transformations after initial load | |
LOAD Upper(Name) as Name;LOAD * FROM source.qvd; | • Loads from the immediately preceding LOAD or SELECT without specifying a source • allows stacked transformations in one pass | |
Mapping LOAD OldCode, NewCode FROM map.csv; | • Creates a two-column mapping table for use with ApplyMap() • table is not added to data model | |
Crosstable(Month, Sales, 2)LOAD * FROM pivot.csv; | • Unpivots crosstab data into row format • first parameter is attribute field, second is value field, third is number of qualifier columns |