Drill Down Visualization-Qliksense

[sakthi266]

Hi Team, 

            Good evening, 

                          I have a issue in Qliksense Drill Down Visualisation. We have a multiple Level manager as L1, L2, L3, L4, L5

Ex.  For L1, L2 is the Child. For L2-L3 is the Child. 

So Created Master dimension as New - Drill Down - Added L1, L2, L3, L4, L5

IF I click L1, it should go to the L2 which is next level. but it is skipping to L4 Which is wrong behavior as Drill down for L2 level is expecting more than one value. 

Explained with example in the attachment of Excel. 

Please consider and reply back immediately as it tooks so many days. 

Regards 

Sakthivel. S

[justISO]

Hi, I guess that such behavior of drill-down can be that if in level is only one distinct value then that level is skipped and the drill goes down to the next level with multiple values.

https://help.qlik.com/en-US/sense/August2021/Subsystems/Hub/Content/Sense_Hub/Dimensions/drill-down-...

'When you use a drill-down group as a dimension in a chart, the chart uses the first field in the group's list of fields that has more than one possible value. If the currently made selections cause the field to have only one possible value, the next field in the list is used instead, provided that it has more than one possible value. If no field in the list has more than one possible value, the last field is used anyway. '

Similar post about this is here, where few 'workarounds' were suggested too:

https://community.qlik.com/t5/New-to-Qlik-Sense/Drill-down-master-dimension-skipping-a-level/td-p/15...

[sakthi266 · Accepted solution]

https://community.qlik.com/t5/App-Development/Configure-a-drill-down-dimension-by-typing-its-name-in...