Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us March 10th, 7 ways modern analytics can help you take smarter action. 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.

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
Kush
MVP
MVP

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)

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