Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
and how its shown in the table
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
Looks like you need to order by Total Score desc, Base desc
Unfortunatelly nothing changes when i do that
Change the autonumber and order by to below
Autonumber(Group &TotalScore&Base,Group) as Rank
And
Order by Group,TotalScore,Base Desc;