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: 
Qlik1_User1
Specialist
Specialist

RANK function help

Hi All,

Is it possible to break the grouping of rank like  instead of 8-15 result should be like 8,9,10 and so on, even if the field(sales) on which rank calculation is done has same values like in this case '0'.
RANK(TOTAL Sum({<id={'a','e'},year={"$(=max(year))"}>} (sales)))

Qlik1_User1_0-1654699759783.png

 

Labels (5)
1 Reply
HugoRomeira_PT
Creator
Creator

Hello,

You can achieve this with the following expression:

 

Num(RANK(TOTAL Sum({<id={'a','e'},year={"$(=max(year))"}>} (sales)), 4))

 

Hope it helps!

If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.