How to make the rank as a static

[35677]

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.

[stevejoyce]

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)