Drill-down from a Pivot Table

[Anonymous]

Hi Krishna,

How to achieve drill down from Pivot Table in Qlik Sense . Can you please explain me .

Regards,

Chirag

[balabhaskarqlik]

Check these:

https://community.qlikview.com/thread/283135

https://www.climber.eu/pl-extension-for-qlik-sense/

[kaushiknsolanki]

Hi,

You must create a master dimension for that, which will be a drill down dimension and then you can use that in pivot or any chart form.

Creating master items - Qlik Sense - YouTube

Regards,

Kaushik Solanki

[Anonymous]

Thank you Bala for you Time .

But I am looking to achieve something what Krishna has achieve it below :

Drill down functionality in Qlikview

But I want this to work in Qliksense .

[Anonymous]

But I am looking to achieve something what Krishna has achieve it below :

Drill down functionality in QlikView

[Anonymous]

Requirement: When user clicks on a Balance in the straight table, let's say that user clicks on 11460000, then another sheet should be opened with data displaying the records that make up 11460000. I would need this to do on Balance column only as I may add more dimensions to the straight table.

Category	Balance
Assets	11460000
Liability	14000000
OFB	80000
MISC	85000

[kaushiknsolanki]

Hi,

It has been done using the hide and show functionality of Qlikview.

That functionality is not available by default in Qlik Sense as of now.

You would need some kind of extensions to do that.

Check below post for more help and some links to extensions.

Can Show/Hide is possible in qliksense?

Regards,

Kaushik Solanki

[newuser]

Hello - was any solution discovered for this? The show/hide container object nor the drilldown group didn't seem to fulfill the use case, i.e., being able to click on a pivot table measure to see the underlying values.

[Scott2]

Hi All, did anyone find a solution for this use case, i.e., being able to click on a pivot table measure to see the underlying values.? thanks