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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
GeorgeEard
Contributor III
Contributor III

KPI ranking

Hi,

Does anyone know why every partner (FW Account Name (report name)-Partner) I select is giving the rank of 1 in my KPI?

Im using the formula : =aggr(rank({<[FW Account Name (report name)-Partner]>}(Scores)),[FW Account Name (report name)-Partner])

where 'scores' is a master measure 

GeorgeEard_0-1741874407994.png

Scores:

GeorgeEard_1-1741874462497.png

GeorgeEard_0-1741874583203.png

 

 

Labels (1)
3 Replies
MatheusC
Specialist II
Specialist II

@GeorgeEard 
Try ignoring the selection:


{<YourSelection=>}aggr(rank({<[FW Account Name (report name)-Partner]>}(Scores)),[FW Account Name (report name)-Partner])


- Regards, Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
GeorgeEard
Contributor III
Contributor III
Author

Thank you for the reply,

Do you mean add '{<YourSelection=>}' to the measure in the KPI?

If so I changed the measure in the KPI to {<YourSelection=>}aggr(rank({<[FW Account Name (report name)-Partner]>}(Scores)),[FW Account Name (report name)-Partner]) and the same issue is still occurring.

MatheusC
Specialist II
Specialist II

This YourSelection is an example, then you put the filter field example if your filter field is Customer then it stays:

{<Customer=>}


Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!