How to keep Excell source format in NPrinting Report

geam1988 — Wed, 05 Dec 2018 09:25:23 GMT

Hallo,

From Nprinting, i am getting following Excell file. in QlikView, product name is only once but in Nprinting report it is more time as well as year (Jan)

Report look like this in QlikView. How can i keep Source formet in Nprinting Report ?

Best Regards

Kazi

Re: How to keep Excell source format in NPrinting Report

Ruggero_Piccoli — Wed, 05 Dec 2018 10:55:07 GMT

Hi,

Please always specify the version of Qlik NPrinting you are using and post a screenshot of the template. For example it is not clear if you dragged and dropped a QlikView pivot table as a single tag in Excel or you rebuild it by using Excel pivot features.

In the second case you can use Excel pivot tables native formatting features. Refer to https://help.qlik.com/en-US/nprinting/November2018/Content/NPrinting/ExcelReports/Pivot-table-Excel.htm

Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

topic Re: How to keep Excell source format in NPrinting Report in Qlik NPrinting

How to keep Excell source format in NPrinting Report

Re: How to keep Excell source format in NPrinting Report