Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to drill through to details in a Pivot Table

Hi ,

I have a requirement where I have to show the summary level data  and then show the details ?

Here are the details of the requirements . In below example I am showing count of postcodes at the intersection of two dimensions in a Pivot Table. If the user click on any cell ( as circled from the blue pen ), I have to show corresponding postcode values . How can I do that ? Post code values are something like this 2000 2009 2010 2011 2015 2016 2018 2019 2020 2021 . So in the first column if user clicks on 110 , user should see those 110 postcode either in a map or in a separate table. Please let me know if anyone knows about this .

I will really appreciate it.

Thanks

Aj

2 Replies
robert99
Valued Contributor II

Re: How to drill through to details in a Pivot Table

The ways I have done this is to

Get the user to click on the two dimensions (not the number) and then either depending on circumstances

  • have a map or straight table beside the pivot table
  • at times I have set up a drill down in the pivot table (set up as a master dimension)
  • set up as unticked "fully expanded" with the 2 required dimensions
praveenak
New Contributor II

Re: How to drill through to details in a Pivot Table

Hi Ajay,

Did you get any solution on this?

Please provide if anything you found.

Thanks.