· Qlik Sense · Series · 5 articles
Henric Cronström’s Technical Briefs, revisited for Qlik Sense
Joins, NULL, generic keys, IntervalMatch, hierarchies, incremental load: a series adapting classic Qlik data modelling references to Qlik Sense.
[ blog ] · 10 articles
Tag: Data modelling
- Joins and lookups in Qlik Sense: when to link, when to join
- Generic keys in Qlik Sense: linking data that do not share the same granularity
- Generating missing data in Qlik Sense
- IntervalMatch and slowly changing dimensions in Qlik Sense
- Hierarchies in Qlik Sense: from parent-child table to access rights
· Qlik Sense
The Semantic prefix in Qlik Sense: moving from parent to child in one click
Semantic creates a relation field to walk a tree or a graph one level at a time. Its four fields, how to use it, and how it differs from Hierarchy.
· Qlik Sense
The Generic prefix in Qlik Sense: from attribute-value data to dimensions
Generic turns an attribute-value table into one table per attribute. How to use it, combine the result into one table, and avoid duplicates.
· Qlik Sense
The Qlik Sense developer checklist: script, model, naming, security
A QlikView development checklist updated for Qlik Sense: script, data model, naming, Section Access, performance and delivery, item by item.
· Qlik Sense
Starting a Qlik project: exploring and extracting the data
The blog’s first article, on the first step of a Qlik project, understanding the structure of the source database and then exploring its content.