Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Data modelling issues in QV?

Hi Guru's,

Please let me know what are the data modelling issues (apart from Synthetic key & Circular reference)  faced in QV?

Immediate responses could be appreciated.

Sree

2 Replies
rustyfishbones
Honored Contributor II

Re: Data modelling issues in QV?

Always check the Subset Ratios of Joins.

So if you are joining the Product Dimension Table to the Event Table Check the Subset Ratio to have a better Data Model, see below example, the Product Dimension linked to the Product Transactions has a Subset Ratio of 81%, which is not too bad, but ideally you want this at 100%, anything lower the 80% is a concern as you could be holding thousands of products that will have no transaction to select against

2014-01-25_1249.png

Re: Data modelling issues in QV?

Another one to look for are tables that only have two fields - using a mapping load to bring the associated data into the parent table is more efficient.