Skip to main content

Qlik

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
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
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

 

376 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.
353 Views