Showing top 5 values

[#1]

Hi all,

I have a straight table with dimension as Account# and two expressions as sum(account#) and count(account#).

Requirement is to show only top 5 values among all values. Can anybody help me to get only top 5 values against available dimension??

Hope got my question.

Thanks,

Shailesh

[#2]

did you try dimension limit option???

[#3]

I can go for that but i have Qlikview 10 in my system since it does not have dimensions limit option.

Is there any way to get the output?

Regards,

Shailesh

[#4]

then instead of that, you can use rank function.

[Agis-Kalogiannis]

Hi Shailesh

This is an example of the Rank() function that will give you the top 5 products according to their sales

Use this as a calculated dimension

=aggr(

if(

  rank(sum(Sales)) >= 1 AND rank(sum(Sales)) <= 5,

  Product

  ),

Product

)

Regards

Agis