Qlik Community

New to Qlik Sense

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

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
martin_caruso
Contributor III
Contributor III

Rank in Chart: KPI

Hello! Good afternoon!


I was presented with the following problem and would like to know if anyone could help me.


I have a table with the following values, which is assigned a ranking according to the amount.


Header 1Header 2
Europe100
Oceania20
Africa40
Asia80
America75


On my dashboard, I want you to select a continent (for example, America) in a KPI that ranks # 3.

I am using the ranking function, it shows me ok in the table but doing so in the KPI indicates the value 1.

I look forward to your cooperation.

Thank you very much!

Regards!

1 Solution

Accepted Solutions
sunny_talwar

I don't think multiplying by Avg(1) is needed, this should be enough in itself

Aggr(Rank(Sum({<Company = >} Amount)), Company)

View solution in original post

4 Replies
mikecrengland
Creator III
Creator III

I had to do something similar  on a 'Top 100' chart, putting the rank on the axis of the bar chart. The expression is:

Aggr(Rank(Sum({<Company = >} Amount)) * Avg(1), Company)

It keeps the original ranking when you filter to a (or several) companies.

mike

sunny_talwar

I don't think multiplying by Avg(1) is needed, this should be enough in itself

Aggr(Rank(Sum({<Company = >} Amount)), Company)

martin_caruso
Contributor III
Contributor III
Author

Sunny, thank you very much for the help. It worked!

Regards!

martin_caruso
Contributor III
Contributor III
Author

Mike, thanks for the help. I was helpful!

Regards!