Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
EugeniaCastilla
Contributor
Contributor

Limit to top 5 the first and second dimension of a drill down in a chart

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

 

2 Replies
Digvijay_Singh

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.

Digvijay_Singh_2-1660355934139.png

Digvijay_Singh_3-1660355954502.png

 

 

 

 

EugeniaCastilla
Contributor
Contributor
Author

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.