Drill down for charts and pivot tables

[dreweezy]

Hi all,

I have created a drill down dimension that goes something like this.

Year -> Category -> Project Name -> Project Activities -> Project Expense ($)

The issue I am seeing is that my drill down sometimes skips levels and doesn't show the full breadcrumb on how it got to the 'Project Expense' item. When I validate this data in my database (joining 3 tables) I am able to see that breadcrumb on Year/Cat/ProjectName/ProjectActivities/Project expense. Is there a way I can tell Qlik to explicitly go through each drill down as expected? 

[Lisa_P]

It is likely this behaviour is due to the data. If you have other filters on, or there is no activities would be reasons to go to the next level