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

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
rainstorm90
Contributor
Contributor

Rank within sub group

I have the following table which I need to rank each person by their group. I will need to create a KPI object with the rank for the person selected. For example if Leo is selected, even if his rank is 3, the rank within his group should be 2. 

I have already created a variable to get the current group for the person selected. Can someone show me how can I get the rank within sub group? Thank you!

Capture.PNG

0 Replies