topic Re: data model best practises in QlikView

data model best practises

Wed, 25 Nov 2020 16:16:04 GMT

what are the best practices should be followed while designing qlikview data model

Re: data model best practises

marcus_sommer — Thu, 01 Dec 2016 20:15:21 GMT

You might be starting here: Get started with developing qlik datamodels.

- Marcus

Re: data model best practises

krishnacbe — Thu, 01 Dec 2016 21:29:04 GMT

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

Re: data model best practises

Fri, 02 Dec 2016 05:43:31 GMT

Hi,

Please go through this document. It might helpful to you.

Thanks!!

Br,
Habib Shaik.

Re: data model best practises

Vegar — Fri, 02 Dec 2016 05:46:32 GMT

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/

Re: data model best practises

Fri, 02 Dec 2016 14:44:04 GMT

what are the commonly used script level operations involved during data modeling, i know join , concatenate and applymap

Re: data model best practises

marcus_sommer — Fri, 02 Dec 2016 15:35:26 GMT

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

Re: data model best practises

Fri, 02 Dec 2016 16:04:49 GMT

what are commonly used transformations while designing data model

Re: data model best practises

cheburashka — Thu, 19 Jan 2017 12:17:39 GMT

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.