topic Re: Dimension limits and rank in QlikView

Dimension limits and rank

Sun, 09 Mar 2014 17:58:52 GMT

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.

Re: Dimension limits and rank

Clever_Anjos — Mon, 10 Mar 2014 00:20:39 GMT

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?

Re: Dimension limits and rank

jagan — Mon, 10 Mar 2014 01:56:10 GMT

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.

Re: Dimension limits and rank

Mon, 10 Mar 2014 04:20:36 GMT

Grate Idea...

Re: Dimension limits and rank

Anonymous — Mon, 10 Mar 2014 05:31:24 GMT

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.

Re: Dimension limits and rank

Mon, 10 Mar 2014 12:57:45 GMT

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

Re: Dimension limits and rank

jagan — Tue, 11 Mar 2014 03:09:17 GMT

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.