Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to lock the chart at a lowest drill point ?

My chart has its x-axes having a drill dimension (2 steps) for location and measure is head count.

X axis shows 'Region' at high level which included Asia, NA, Africa etc and on clicking any bar (say for example Asia), I get to see the drilled down chart for Asia region showing the measure for various locations in Asia. Yes, the typical drill down chart.

Now my requirement is...the chart of course will allow the user to click on a region and see the sub region wise split. But I dont want user to click on a sub region to select it again. That is, after the first drill, I want to lock any further drill down attempt. But user should be able to drill up (back) to region level also.

Is this possible ??

1 Reply
Not applicable
Author

Ignore the Sub Region selection in the calculation expression using set analysis. Try changing your expression inline with the below one,


SUM({<[Sub Region]=>}[Head Count])


hope this resolves your issue.

-Haneesh