Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
say I have a drill down dimension and I include it in a pie chart.
Drill down dimension: Country - Region
the Measure = sum(sales)
I want to only show the top 5 countries in the pie chart.
Then, if a user selects a country, only the top 5 regions should be showing.
How can I do this? I am having trouble limiting the top 5 of the second level of the drill down
I was just trying this and found that the dimension limit is working for all the dimensions in the drill down, I haven't used this but don't you see top 5 region automatically in your chart like I see below. We are on Nov 2021 Qlik Sense version.
In my case, for bar charts your approach works. But for pie charts it only limits the first level of the drill down, not the second.