Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Drill down step Missing problem

Hi Guru's

i have 7 Fields like below .and i created drill-down group in same order

1.Year ->2.Region->3.Health authority->4.GXP Area->5.Site Type->6.Site->7.Phase

expression:count(inspections)

if i click on year=2013 its drilling  down to Region

if i click on  Region=Americas its drilling down to Health Authority

if i click on Health Authority=PPL its drilling down and jumping to Phase(last step)

Problem:  Jumping these steps:  4.GXP Area->5.Site Type->6.Site

4.GXP Area->5.Site Type->6.Site  ,these steps data is not showing.


please find the sample data

2 Replies
Anonymous
Not applicable
Author

Health Authority=PPL only contains a single Site Type=Manufacturer, and so for a drill down QlikView skips it.

Anonymous
Not applicable
Author

hi thanks for your Time.

can you please suggest me is there any possibility to display all 7 levels without fail?