topic Re: Dimension limits in QlikView

Dimension limits

anushree1 — Tue, 05 Dec 2017 10:23:25 GMT

Hi,

I have few questions in regard to Dimension Limits :

1. Are Dimension Limits better option when compared To the usage of Rank and AGGR Functions

2. Supposedly I restrict based on First Expression and give a condition to show largest 10 values , i still happen to see more than 1000 rows.(I have around 4 dimensions) and I have applied the same dimension Limit on all the 4 Dimensions, can anyone let me know where I have gone wrong here.

3. Will dimension Limits work on Multiple Dimensions and Expressions

4. Will dimension Limits work on negative values.

5. What are the Limitations of using Dimension Limits

Re: Dimension limits

anushree1 — Fri, 08 Dec 2017 07:47:09 GMT

Any Suggestions?

Re: Dimension limits

neha_shirsath — Fri, 08 Dec 2017 07:54:52 GMT

This criteria are evaluated with the first expression of the chart, though you have multiple expression.

Probably you can read the below blog for more info-

https://community.qlik.com/blogs/qlikviewdesignblog/2012/08/24/qlikview-11-dimension-limit-functionality

Re: Dimension limits

neha_shirsath — Fri, 08 Dec 2017 07:59:00 GMT

You can avoid to use Aggr function, if it is not required to use then try to avoid in your app as it slows down your app performance drastically.