how to find top 6 sales in pivot table ?

[Vamsy1991]

Hi,

I am hari. I am new to Qlikview. Could you please explain how to find top 6 sales in pivot table ?

[qlikview979]

Hi,

may be this

write in expression like this  as per your fields

if(aggr(rank(sum(sales)),product)<=6,product)

How to get Top 5 Sales?

for your reference