Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
lichang422
Creator
Creator

How to make a rank table

Hello,everyone

I have a subject grade table.I want to make a rank table like the following picture.

When I select one man. It will show rank percentage at every subject.

How could I do that??

 

 diagram.jpg

 

 

 

Labels (1)
5 Replies
Channa
Specialist III
Specialist III

=If(Aggr(Rank(Sum(value)),Country)<=$(vMeasure),Country)

=If(Aggr(Rank(Sum(value)),Country)<=5,Country)

general rank by dimension

 

$(vMeasure) can be variable or static 

 

hear u will get top 5 countries based on value , try similar

Channa
lichang422
Creator
Creator
Author

Sorry , I can't make it successfully.
Can you make a sample for me by attachment.
Thank you for your reply.
lichang422
Creator
Creator
Author

I am not sure that do I explain it correctly.

Let me explain it again.

Now I have 5 people to rank .

When I select one man like "蔡宗霖"

It will show 蔡宗霖 at CNC ranking ratio.

He is  top 2 at all men(5 people),So he win 80% people.

Diagram like following.

How could I do that ?

Thank you.

Picture.png

Channa
Specialist III
Specialist III

from the total people of 5 how you get 80% for 2nd

or you showing like top 5 under 80%

and top 10 under 70....

Channa
lichang422
Creator
Creator
Author

How could I get 80% for 2nd?
Because his grade is at 2nd and he is better than 80% people.