Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
EliasGPS
Contributor
Contributor

I need a suggestion

I'm showing alot of countries in a pie chart and it shows the percentage of how many a country has lost forest area. (in the sceenshot you can see an example).

 

Now i have soo much countries that it is so hard to read.

What should i do? Should i use another chart or?

Thanks for any suggestions!

EliasGPS_0-1681918208168.png

 

Labels (1)
3 Replies
mfchmielowski
Creator II
Creator II

Pie chart is good to show shares in my opinion. First option is to show it splited into continents - other piechart for each continent.

EliasGPS
Contributor
Contributor
Author

In my pie chart i can change the dimension to this:

  • =if(GeoType = 'Region', GeoAreaName)

Than i will get all the regions but when i get soo many regions (look screenshot)

This is also not good.

EliasGPS_0-1681928180216.png

 

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi @EliasGPS 

The TreeMap is a similar chart type which handles small values better, but be careful as you should only use either of those charts if all the wedges (or boxes) add up to 100%. If you are saying that Brazil has lost 20% of its forest and DRC has lost 12% of its forest they should not go into a pie chart or a treemap. If you are saying of the forest lost in the world Brazil is 20% of that total and DRC is 12% of that total that is fine.

The bar chart is always a good answer in Sense, not least because of the scroll to get to the long tail of the data, and the fact that it doesn't have to be the share of a total.

Hope that makes sense.

Steve

https://www.quickintelligence.co.uk/blog/