I have created one Drill Down Group named 'Details'
Under 'Details' we are using 3 fields:Status,Priority,Risk
Created Bar chart using Details group in Dimension:
It is working in following way:
By default is it showing Status Bar.
When clicking on Status Bar, Priority data is shown.
When clicking on Priority Bar, Risk data is shown.
With most of the data it is working fine. But issue is that for some of the data when i am clicking on Status it is not showing Priority data and directly showing Risk data.
Can you please help me in identifying issue and can suggest how to resolve it.
The drill-down function automatically goes down to the next level when there is only one value on the current level. So what happens is most likely that you for some data only have one value in your Priority field.
If you make a selection in Status and then only have one value in Priority, the drill-down will automatically take you down to the Risk level. This cannot be changed.
If you still want to show the Priority level, although there is only one bar, then you should change the group to “Cyclic” instead of “Drill-down”.
The definition of a drill-down is to automatically skip to the next level when there is only one value. So, that is what QlikView does if you have chosen a drill-down group.
If you instead want to manually decide when you change level, you can define it as a cyclic group. Same logic, but now you can decide yourself when to skip to next level.
.png "Former Employee"){kind=icon}