How to drill down and see the records of visualizations?

[Anonymous]

I am new to Qlik. Is there anyways that we could see the records or drill down to detail of a selection in Qlik similar to drill down in Tableau or view records in PowerBI? ( similar to the snapshot below)

[YoussefBelloum]

Hi,

I can recommend you this:

1.     Create a drill down dimension

2.     when you reach the desired dimension whith a drill down (on a bar chart for example), right button, export as data.

or

you can show values on top of the bars

[Anonymous]

Can you provide and example on how to create drill down dimension. Are you referring to add alternative dimension?

[YoussefBelloum]

No, Drill down dimension and alternative dimension are different features.

for drill down, you can do like described on the pic (I don't think it is necessary to translate):

Step 4: choose the dimensions (sorted the way you want) that you want to use on your drill down.

when you validate Step 5, you will see a logo appearing below the master dimensions, just use this master dimension (drop it directly on the chart you already use and choose replace) to be able to drill down between the dimensions you choose when configuring your drill down.

[Anonymous]

I got that but how do you apply that drill down? for instance if I want to see the drill down of the slice of the chart above, how would you apply this new dimension to see the underlying records?

[YoussefBelloum · Accepted solution]

EDITED

to apply your drill down on a chart:

1. on the right panel, use the drill down name on the dimension name (change your actual dimension) THIS IS NOT POSSIBLE

2. drag and drop the drill down dimension from the left panel to your actual chart.

to navigate through your dimensions using the drill down, just click on any value (a bar for example), the chart will move automatically to the second dimension defined on the drill-down dimension.

[Anonymous]

Thank you!

[YoussefBelloum]

you're welcome.

Good luck