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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
adias102
Contributor III
Contributor III

Rank based on KPI

Hi,

I have an application that shows several measures for departments.

The basic display shows all the data for a chosen department (only 1). All the data is KPIs and I calculate several grades for each department and a final grade.

G1 - total sales for this department relative to max sales, value between 0 to 100.

G2 - total expenses relative to max expensesת value between 0 to 100.

G - G1 * 0.6 + G2 * 0.4.

Now I want to add a KPI to display the rank of this department based on G.

 

If I use a table and show all the departments then the rank measure is workung fine.
If I choose one department then the rank shows 1.

How can I ignore the chosen dimension value? I read many threads but I don't use a sum function or something like it to add a set analysis.

0 Replies