Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
GraceGao
Creator
Creator

Ranking Number

Hi Experts

How can add ranking number in the pivot table as below?  I have set fixed top 10 product in the pivot table and want to add one ranking number in front of product. Please help. Thanks.

GraceGao_0-1606541359745.png

 

1 Reply
MayilVahanan

HI @GraceGao 

Try like below

Dim:

=Aggr(If(Rank(Sum(Sales))<=10, Rank(Sum(Sales))), Product)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.