Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
GraceGao
Creator
Creator
‎2020-11-28 12:30 AM

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

 

573 Views
1 Reply
MayilVahanan
MVP
MVP
‎2020-11-28 12:56 AM

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.
550 Views