In Nprinting excel Report Need to hide the Qlik Sense Pivot table column

[sat_tok52]

Hi All,

I am preparing Nprinting  excel report , I am adding pivot table in that excel report ,but pivot table acts like a image I can't pull by individual columns like straight table, so in that pivot table I have to hide one column at Nprinting level. Any help on this.

Thanks.

[Patricia_Silva]

Hello @sat_tok52 are you placing the pivot table from Qlik Sense as image in NPrinting editor template? Here's a guide about Pivot Tables in NPrinting that I think it might help you: 

https://help.qlik.com/en-US/nprinting/February2021/Content/NPrinting/ExcelReports/Pivot-table-Excel....

[Lech_Miszkiewicz]

It is not possible to pull individual columns from pivot table. More details on https://help.qlik.com

Workarounds:

• create new object in Qlik Sense without the column and use that in NPrinting
• or use straight table and build Excel based pivot table (using excel pivot table functionality)
• use image and conditionally hide column (that can be achieved by variable filter)

regards

Lech