Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
We have 60 ranks in a table chart, when a particular ID is selected we need to show the rank for that particular ID.
For example:
ID | Logic | Rank |
33 | Logic | 1 |
77 | Logic | 2 |
11 | Logic | 3 |
88 | Logic | 4 |
99 | Logic | 5 |
22 | Logic | 6 |
55 | Logic | 7 |
44 | Logic | 8 |
66 | Logic | 9 |
In Qlik sense, If we select 99 ID it is showing Rank "1" but I need the Rank as "5". And I need to show the rank in KPI object also.
Please guide me to solve this issue. Thanks in Advance.
You'd need to ignore your filter selection that you don't want to impact recalculating of rank. So in this case add to your set analysis {<ID = >}.
If you only want to display the selected row with this rank, you can multiply by 1 that takes your filters like:
Rank(sum({<ID= >} value)) * count(distinct 1)