Qlik Community

Qlik Sense App Development

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

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
Valued Contributor II

Re: Drill dwon on the values in Pivot table in Qliksense

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.