topic Re: Pivot Table Headers Disappearing in Qlik NPrinting

Pivot Table Headers Disappearing

neil-devlin — Thu, 10 Nov 2022 15:54:36 GMT

For some reason my Nprinting reports randomly display and then dont display specific pivot table headers despite nothing changing on the qlik app, or in the Nprinting tablet, does anyone know why this is? Its frustrating as I need reports to remain static to allow our accounts team to use vlookups etc

Example pictures attached

Re: Pivot Table Headers Disappearing

Frank_S — Thu, 10 Nov 2022 18:51:12 GMT

I will assume you created an NPrinting Pivot table with QlikView or Qlik Sense data.

It is very important to follow the steps in this help page from end to end.

Please have a look and perhaps even create a new report with these details steps.]

It should work therein.

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

Kind regards...

Re: Pivot Table Headers Disappearing

Lech_Miszkiewicz — Thu, 10 Nov 2022 21:49:51 GMT

@Frank_S - that is different scenario as we are talking here about native QlikView pivot table export (not the excel).

I think this has something to do with the "always fully expanded" setting in QlikView or the way we can drag&drop dimension in QlikView to the header section above or below measure label.

I agree with Frank, that in order to work around it and i think get it done properly you would follow steps by creating in QlikView straight table, you then use this straight table as data source for your NPrinting report in which you build native excel pivot table which will not have those formatting issues.

Re: Pivot Table Headers Disappearing

neil-devlin — Fri, 11 Nov 2022 09:22:30 GMT

Hi Frank,

Up until now we have been using NPrinting to export the entire object (Pivot table) from a Qlikview app rather than cell by cell creation. Is this something we should not be doing then?

Re: Pivot Table Headers Disappearing

neil-devlin — Fri, 11 Nov 2022 10:13:31 GMT

Yea thats exactly it Lech, I am exporting a native Qlikview pivot table as an object to Nprinting, it works for the most part apart from the randomly moving top row header/label. Reading what you and Frank have said it appears this isn't a good idea?