Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Mstucchi
Contributor
Contributor

Format QlikSense Tabel/Pivot Object in NPrinting

Hi All,

I'm quite new to Nprinting, I have developed a report which uses Qlik Sense tables and pivot.

Because of the size of the objects, when are added to the report, numbers appear too small when the report runs in PPT output.

Is it possible to set formats to object in the NPrinting report which override the default format (size)?

Thanks in advance for assisitance!

Regards

Massimo

Labels (2)
1 Reply
Frank_S
Support
Support

What you can do is make a copy of your Qlik Sense pivot table (this must be done in Qlik Sense) and convert the copy to a straight table. (or just make an new straight table using the same fields as the original Pivot Table.) 

You can now use the straight table to create your own Pivot table using Qlik Sense data (or QlikView. The articles below references QV but apply to both QV and QS).

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

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

By removing 'Keep source formats' in the NPrinting template editor for the straight table chart, you will then be able to utilize your own formats entirely.

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!