topic Re: rank and dimension limits in QlikView

rank and dimension limits

Sat, 30 May 2015 19:46:11 GMT

which one is the best in terms of performance to use either rank() function or dimensional limits to get the top 10 values?

Re: rank and dimension limits

robert_mika — Sun, 31 May 2015 06:17:49 GMT

I would suggest the Dimension Limit as is already build it functionality already optimized for this task.

Re: rank and dimension limits

Sun, 31 May 2015 06:53:20 GMT

Dimension Limits

Re: rank and dimension limits

pratap6699 — Sun, 31 May 2015 20:40:44 GMT

assume that sum(sales) is our expression and employee is dimension ...u need to display to 10 employee sales dynamically right? we use aggr funtion with rank() we done this requirement....

at conditional dimension-->=Aggr(If(rank(Sum(sales))>=20,employee),employee) exp-->sum(sales)

Re: rank and dimension limits

pratap6699 — Sun, 31 May 2015 20:41:37 GMT

=Aggr(If(rank(Sum(sales))>=10,employee),employee)

Re: rank and dimension limits

Mon, 01 Jun 2015 00:56:01 GMT

I would recommend Dimension Limit as it is built-in Function and made for limiting Dimension values and will have better performance.

Re: rank and dimension limits

awhitfield — Mon, 01 Jun 2015 11:48:13 GMT

Another vote for DIMENSION LIMITS

Andy

Re: rank and dimension limits

Mon, 01 Jun 2015 12:12:37 GMT

Unless you are looking to use a pivot table (or another object with similar constraints), dimensional limits is the way to go

Re: rank and dimension limits

Mon, 01 Jun 2015 17:24:53 GMT

Thank you all for your replies..

but may i know the difference between those two rank() and dimensional limits?

Re: rank and dimension limits

pratap6699 — Mon, 01 Jun 2015 20:21:31 GMT

rank() returns the quantity wise sales by dynamically through expression....but dimension limits also return the same thing without using expression...but sometime in conditional damension we use aggr & rank() as per requirement