Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
praveenak
Partner
Partner

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.