Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
IMPORTANT: PLEASE READ - Labels will be required in the NPrinting forum starting on Friday September 26, 2019: Click here for details and instructions.
Mstucchi
New 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

1 Reply
Support
Support

Re: Format QlikSense Tabel/Pivot Object in NPrinting

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.

We are just 'like' you & like to be liked when we provide a helpful answer and or when you press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!