Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
what are the best practices should be followed while designing qlikview data model
You might be starting here: Get started with developing qlik datamodels.
- Marcus
Hi,
Below are few Best Practices
1. Avoid Synthetic Keys & Circular loops
2. Try to build Star Schema to increase the performance
3. Use QVDs to load more faster
4. Optimize the load.
I too agree with Marcus for details information
Hi,
Please go through this document. It might helpful to you.
Thanks!!
Br,
Habib Shaik.
I think this is a good read by richard.pearce60. It will help your understand .
https://qlikcentral.com/2014/08/19/the-optimal-qlikview-data-structure/
what are the commonly used script level operations involved during data modeling, i know join , concatenate and applymap
I will always depend to the concrete load/transforming-task which kind of script-operations will be more suitable to your requirements - there is no global rule: A perfect datamodel?
- Marcus
what are commonly used transformations while designing data model
Hi vibhu,
I've created some QvM - Qlikview Modules that I use to help me do validations like KeyChecks, interactions between selections in one table and another, etc.
Maybe you'll find them useful.
,KR Koen
PS: Don't forget to mark answers as helpful and correct.