Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Vamsy1991
Contributor
Contributor

how to find top 6 sales in pivot table ?

Hi,

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

1 Reply
qlikview979
Specialist
Specialist

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