Displaying the selection in Drill Down Hierarchy group
Need one urgent help on displaying selection value of the drill down hierarchy selections. I have been struggling to make this work, but QlikView default behaviour is confusing.
Please see the attached sample file for more clarity. I have also attached the excel data.
1) There is a drill down group with three dimension. Dim2 has one selectable value for Dim2 = 'Nail Cutter' for Dim1 = 'Self Care' . Thus when I click on Self Care, QliKView jumps to Dim3 directly and skips Dim2 as there was only one value. Unfortunately while doing this, it does not itself select that one single value in Dim2 (Nail Cutter).
Thus my label logic to display the value of currently selected hierarchy level fails. here is the logic I am using: