Showing to 5 customers: Which is better - Dimension Limits or Calculated dimensions

[#1]

HI

If I want to show the top 5 customers, I can create a Calculated Dimension such as:

Option 1

= if(Aggr(rank(sum(Revenue)),Name) <= 5, Name)

Option 2

I can get the same result by simply doing a sum(Sales) and forcing it to show the top 5 under the Dimension Limits tab.

The question is, which is more efficient / better to use on a large data set of 100m+ records.

Thank you.

[shree909]

i think option 2 is better , here the values are already calculated

but for the option 1 u are calculating at the cart level. and using a if condition,

so option 2 would be better.. for this kind of ca;lculations they have introduced the dimension limits from 11 qlikview.

. this is my view.

[#3]

Hai,

I Agree With Sree,

Y because if u go by 1 option aagr rank these are Calculation performance will be slow wn u try to open chart

so better to go 2nd Option

Thanks&Regards,

Chandu

[#4]

Under Sheet Objects, Memory usage - it shows the Object with Dimension limits using 8mb, whereas the object using Calculated Dimensions as using 3k.

Are these stats not all that reliable?