drill down to customer level

[Fig1]

I have created stacked bar charts showing completed and not completed documents by speciality and then a further breakdown by unit.  When you click on the unit(within the specialty ) the  completed and not completed numbers show for that particular unit.  What I would like to do would be to click again to show the customers who do not have a completed document for this unit. Is there a way to do this??

[SergeyMak]

Hi Fiona,

Try to create a drill-down Master Dimension in Master items with Unit as first level and  Customer as second.

Then use it in your chart

Best regards,

Sergey

[Vegar]

As @SergeyMak pointed out, Drill down dimension is the way to go. 

Here is a link that shows you how to do it: https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Dimensions/create-dr...