Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.

Get started with developing qlik datamodels

MVP & Luminary
MVP & Luminary

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.

Comments
qlikviewnovice
Valued Contributor II

Good One Marcus!! It is very helpful

Thank you Marcus.

Very informative

0 Likes
daniel_kusiak
Contributor II

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

0 Likes
ecolomer
Honored Contributor II

Hi Marcus,

Good doc

TX's

0 Likes
sujeetsingh
Honored Contributor III

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

0 Likes
padmanabhan_ram
Contributor II

Really helpful

0 Likes
gautik92
Valued Contributor III

very helpful thanks for sharing

0 Likes
tripatirao
Contributor II

Really Very useful

0 Likes
Arjunarao
Honored Contributor II

Hi Marcus Sommer,

Really It is so nice. Thanks for sharing.

0 Likes
john9inno
Contributor

thanks so much comprehensive information

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