top 5 values in pivote table expressions

[Qlik__Vinodh]

Dear all,

I have the dimensions like  Region,Location,desigation for this i need the top 5 counts.

if any one having soluation pls let me know

[Qlik__Vinodh]

I need the top 5 high count value . not sume values. yar.

[jagan]

Hi,

Try this expression

=If(AGGR (rank(sum(Sales)), Customer) <=5 , Customer)

in dimension.

Regards,

Jagan.