Qlik Community

QlikView Documents

Documents for QlikView related information.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

Get started with developing qlik datamodels

Get started with developing qlik datamodels

Compared with many other tools it's quite simple to start with Qlik especially if the datamodels are simple with only one/two tables. But this advance even increased if the requirements became more complex.

It's already possible with only little know-how to develop quite sophisticated data-models. Basis is the associative data-model from Qlik whereby all tables will be connected through key-fields whereby synthetic keys and circular references should be avoided. Thoughts about star- vs. snowflake-sheme, normalization and so on can be widely employed back - it's easier as it looks like:

Circular References

The Table Viewer

Synthetic Keys

Merging Data from Multiple Sources

Fan traps and Chasm traps

To Join or not to Join

Don't join - use Applymap instead

Concatenate vs Link Table

Fact Table with Mixed Granularity

If data don't be loaded from databases else from flat-files they have often problematic data-structures including the lack of data. Beside the following links is the inbuilt file-wizard from QlikView a powerful but not well documented tool - helpful is here the book: QlikView 11 for Developers which is in general very much recommended:

The Crosstable Load

Counters in the Load

Generating Missing Data In QlikView

Most often worked the loading from fields without any problems - if not are these links helpful:

QlikView Quoteology

Automatic Number Interpretation

On Format Codes for Numbers and Dates

Further very helpful is the use of a master-calendar within the data-model:

How to use - Master-Calendar and Date-Values

Here you will get further important topics: Advanced topics for creating a qlik datamodel andMore advanced topics of qlik datamodels.

Beside the above used links you will find many interessting postings here within the qlik community to these topic - the notes here are a good starting point to go further.

Have fun!

Marcus Sommer

ps: within the attachment is a german translation - deutsche Fassung.

Valued Contributor II

Good One Marcus!! It is very helpful

Thank you Marcus.

Very informative

Contributor II

Hi Marcus, thanks for cumulating it all in one place.

Honored Contributor II

Hi Marcus,

Good doc


Honored Contributor III

It is good and to the point. Well even you can enhance it with the performance concepts too.

Contributor II

Really helpful

Valued Contributor III

very helpful thanks for sharing

Contributor II

Really Very useful

Honored Contributor II

Hi Marcus Sommer,

Really It is so nice. Thanks for sharing.


thanks so much comprehensive information

Version history
Revision #:
1 of 1
Last update:
‎06-28-2015 11:00 AM
Updated by: