Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
praveenak
Partner - Contributor II
Partner - Contributor II

Drill dwon on the values in Pivot table in Qliksense

Hi Everyone,

I want to drill down along with navigating to a different sheet on the values in the pivot table like in excel.

For example, considering below sample orders data, when I click on the '120' in the below table I want to see all the related data for that '120' in table object.

pivot.JPG

Please someone provide a solution to achieve this.

Thanks.

1 Reply
undergrinder
Specialist II
Specialist II

Hi Praveena,

such behaviour of excel in Sense doesn't exist.

The link below gives you some example of pivot tables in Sense

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Visualizations/PivotTable/pivot-ta...

The items with '+' sign can show the detail info, but when you want to show Excel like details, you can add a simple table object next to pivot with the desired columns, this case the pivot serves as filter. I think this is not the desired scenario.

G.