topic NPrinting - Pivot Table Misalignment in Qlik NPrinting

NPrinting - Pivot Table Misalignment

Kings — Thu, 06 Feb 2020 09:02:16 GMT

Hi,

I have created a report in NPrinting Designer using pivot tables from a QlikView document. The pivot tables have 2 dimensions - 1 vertical and the other horizontal. The report uses an Excel template and all tables are aligned in the same column.

When exporting the report there is sometimes a misalignment issue or a 1 cell spacing between the dimension and the measure. Attached is an example of this.

Has anyone experienced this issue? If so is there a solution?

Thanks

Re: NPrinting - Pivot Table Misalignment

Ruggero_Piccoli — Thu, 06 Feb 2020 09:40:14 GMT

Hi,

Could you post also screenshots of the Excel template and of the original pivot tables?

What do you get if you preview the report in Excel format?

Please note that end of life for QlikView NPrinting 16 is planned next March.

Best Regards,

Ruggero

Re: NPrinting - Pivot Table Misalignment

Kings — Thu, 06 Feb 2020 11:27:16 GMT

Hi,

I have attached screenshots of the pivot tables I am using in QlikView and also the NPrinting template.

I have previewed the report in Excel and PDF format. Both returning the same outcome. I have also closed and restarted NPrinting and QlikView applications. This sometimes temporarily fixes the issue however, after a while it reverts back to some tables being misaligned.

Sometimes when changes are made in either QlikView or NPrinting different tables are misaligned once the report is previewed.

Re: NPrinting - Pivot Table Misalignment

Ruggero_Piccoli — Thu, 06 Feb 2020 11:49:08 GMT

Hi,

Thanks for the info. If when you have the issue you go to QlikView and do a right click and Send to Excel the pivot tables, what do you obtain? This is what QlikView NPrinting does so you can simulate it manually.

It seems to me that if depends on the data that comes from QlikView that sometimes have the first column empty.

I suggest you to create a single table (pivot or straight) for reporting purposes so you will be sure the columns are aligned in the report.

Best Regards,

Ruggero