Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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
Highlighted
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

Highlighted

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

Highlighted
Contributor III
Contributor III

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

Regards!

Highlighted
Contributor III
Contributor III

Mike, thanks for the help. I was helpful!

Regards!