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: 
apthansh
Creator
Creator

Ranking based on the measure value

I have the below table - I want to rank based on the sales - I have almost 20 columns in the table with multiple dims & Measures

IDSalesLossRank
15000030003
29000040001
37000050002
42000060004
51000070005

 

I tried Rank (Sum( Sales)) which is giving me only 1 as value, instead of 1,2,3,4,5..Not sure why..any thoughts please ?

 

Thank you much.

2 Solutions

Accepted Solutions
Steven_Haught
Creator III
Creator III

You could try this  I use  something similar in a like table for sales ranking:

=Aggr(Rank(Sum(Sales])),ID)

View solution in original post

ramchalla
Creator
Creator

you can try this below formula.

IF(Aggr(Rank(SUM(Sales),4),ID)<=20,Aggr(Rank(SUM(Sales),4),ID))

View solution in original post

3 Replies
Kushal_Chawda

Ideally it should work. Would you be able to provide sample data with expected output?

Steven_Haught
Creator III
Creator III

You could try this  I use  something similar in a like table for sales ranking:

=Aggr(Rank(Sum(Sales])),ID)

ramchalla
Creator
Creator

you can try this below formula.

IF(Aggr(Rank(SUM(Sales),4),ID)<=20,Aggr(Rank(SUM(Sales),4),ID))