Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.