Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
GeorgeEard
Contributor III
Contributor III

Rank not working

Hi, 

I am trying to rank partners based on the variable 'scores' however it is not working, any ideas on how I could fix this would be great.

GeorgeEard_0-1742464630857.png

 

Labels (2)
3 Replies
henrikalmen
Specialist II
Specialist II

Is Scores a variable? What is that variable's expression?

GeorgeEard
Contributor III
Contributor III
Author

Hi yes scores is the variable shown below:

GeorgeEard_0-1742549092819.png

An example of the variables inside 'score' is below

GeorgeEard_1-1742549152391.png

 

henrikalmen
Specialist II
Specialist II

You can try rank($(Scores)) or rank($(=Scores)) but maybe it just won't work. If it's possible to move the calculation, or large parts of it, to the data model you may have better success.