Dimension limits and rank

[#1]

i have crated three charts of aim is top 5 sales

1)using dimension limits

2)=aggr(if(rank(sum(Sales))<=5,Country),Country)----On dimension-

3)=If(Aggr(Rank(Sum(Sales)),Country)<=10,Sum(Sales))---on expression---memory is like

which one is better and performance wise and memory wise.

i want to know how the Qlikview evaluates in this scenarios.

[Clever_Anjos]

I don´t why you´re mixing Dimension Limits and that calculated dimension.

Why don´t you use only Dimension Limits to filter top 5?

[jagan]

Hi Mahesh,

Using Aggr() in expression or dimension have some performance issues, so better to avoid it by using Dimension Limits top N.

Also Calculated dimension also had very bad performance, so better avoid calculated dimensions. 

I think the best option is Dimension Limits.

Regards,

Jagan.

[#4]

Grate Idea...

[Anonymous]

Hi Mahesh,

If You are using the pivot table then in pivot there is no option of dimension limit so in pivot you can apply this thing which you are asking bt in straight table Dimension limit is the best option for the top n analysis.

[#6]

Hi jagan,

what could be the code behind for dimension limits.

1)i have one query that i have read from one blog post applying dimension limits condition on straight table is causing performance issue when the records are more.can you please suggest me.

Regards

Boby

[jagan]

Hi,

With Dimension limits if it is not possible then you have to go for Rank() with If in Expression or Calculated Dimension. 

Regards,

Jagan.