Drill dwon on the values in Pivot table in Qliksense

[praveenak]

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.

Please someone provide a solution to achieve this.

Thanks.

[undergrinder]

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.