Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
SystemError
Contributor II
Contributor II

Calculate Rank on two parameters

Hello everyone! 
I'm calculating the rank of Companies based on their Score. Sometimes there is the same Score for companies and Rank is put randomly. 
I want to calculate rang on other parameter if rank of companies is equal.

Here is how I calculate Rank

 

1.jpeg


and how its shown in the table
2.jpeg

In my example E and F have the same Score, Qlik randomly put 5 for E and 6 for F. 
How to change the order in Rank of these companies based on the condition - who has greater 'base' has higher rank

Labels (3)
3 Replies
Or
MVP
MVP

Looks like you need to order by Total Score desc, Base desc

SystemError
Contributor II
Contributor II
Author

Unfortunatelly nothing changes when i do that

vinieme12
Champion III
Champion III

Change the autonumber and order by to below

 

Autonumber(Group &TotalScore&Base,Group) as Rank 

And

Order by Group,TotalScore,Base Desc;

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.