Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
March 26 at 10am ET: See how Qlik drives growth and value in ISV segment - REGISTER 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.

Labels (1)
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 II
Creator II

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 II
Creator II

you can try this below formula.

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