Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

amosharr
New Contributor II

How to drill down and see the records of visualizations?

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)


Untitled.png

Tags (2)
1 Solution

Accepted Solutions
YoussefBelloum
Esteemed Contributor

Re: How to drill down and see the records of visualizations?

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.

7 Replies
YoussefBelloum
Esteemed Contributor

Re: How to drill down and see the records of visualizations?

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

amosharr
New Contributor II

Re: How to drill down and see the records of visualizations?

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

YoussefBelloum
Esteemed Contributor

Re: How to drill down and see the records of visualizations?

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):

drill down.png

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.

amosharr
New Contributor II

Re: How to drill down and see the records of visualizations?

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
Esteemed Contributor

Re: How to drill down and see the records of visualizations?

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.

amosharr
New Contributor II

Re: How to drill down and see the records of visualizations?

Thank you!

YoussefBelloum
Esteemed Contributor

Re: How to drill down and see the records of visualizations?

you're welcome.

Good luck

Community Browser