Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
anushree1
Valued Contributor II

Dimension limits

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

3 Replies
Highlighted
anushree1
Valued Contributor II

Re: Dimension limits

Any Suggestions?

Highlighted
neha_shirsath
Valued Contributor

Re: Dimension limits

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-functiona...

Highlighted
neha_shirsath
Valued Contributor

Re: Dimension limits

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.