Documents for QlikView related information.
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:
Merging Data from Multiple Sources
Don't join - use Applymap instead
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:
Generating Missing Data In QlikView
Most often worked the loading from fields without any problems - if not are these links helpful:
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!
ps: within the attachment is a german translation - deutsche Fassung.
Good One Marcus!! It is very helpful
Thank you Marcus.
Very informative
Hi Marcus, thanks for cumulating it all in one place.
Hi Marcus,
Good doc
TX's
It is good and to the point. Well even you can enhance it with the performance concepts too.
Really helpful
very helpful thanks for sharing
Really Very useful
thanks so much comprehensive information