Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
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?