Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
martin_caruso
New 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!

Tags (2)
1 Solution

Accepted Solutions

Re: Rank in Chart: KPI

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

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

4 Replies
mikecrengland
Contributor III

Re: Rank in Chart: KPI

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

Re: Rank in Chart: KPI

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

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

martin_caruso
New Contributor III

Re: Rank in Chart: KPI

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

Regards!

martin_caruso
New Contributor III

Re: Rank in Chart: KPI

Mike, thanks for the help. I was helpful!

Regards!

Community Browser