Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
EliasGPS
Contributor
Contributor

Bar chart measure problem

So i'm making a dashboard about forest area.

I want to show the top 10 countries with there highest foreast area loss. I already made a bar chart where i show the top 10 countries with the most foreast area (in the screenshot you can find an example). And i also made a line chart where i can see the evolution of a specific country in a timeperiod from 2000 - 2020. Now i want to make another bar chart where i can show the top 10 countries with the most forest area loss. The problem is only in my measure. i aldready made something like this:

  • Avg({< [Series Name] = {'AG_LND_FRSTN - Forest area (thousands of hectares)'}, Year = {'2020'} >} Value)
    - Avg({< [Series Name] = {'AG_LND_FRSTN - Forest area (thousands of hectares)'}, Year = {'2000'} >} Value)

but i get no result. 

If you need more information don't hesistate to ask for more

Thanks for any help!

Labels (1)
  • Chart

1 Solution

Accepted Solutions
Somasundaram
Creator III
Creator III

=Avg({< [Series Name] ={"=Rank(avg(Value))<=10"}  >} Value)


-Somasundaram

If this resolves your Query please like and accept this as an answer.

View solution in original post

1 Reply
Somasundaram
Creator III
Creator III

=Avg({< [Series Name] ={"=Rank(avg(Value))<=10"}  >} Value)


-Somasundaram

If this resolves your Query please like and accept this as an answer.