topic How to keep QlikSense table format in NPrinting Excel report in Qlik NPrinting

How to keep QlikSense table format in NPrinting Excel report

Anonymous — Mon, 13 Feb 2017 04:14:41 GMT

Hi,

I am trying to put a table from QlikSense into an NPrinting Excel report. Although the table is inserted and I can see all data, the formats and Colors are not taken by NPrinting. I am using the property "Keep source formats" checked. Also if I uncheck it the result is the same. I am using NPrinting 17.3

This is the table with the Qlik Sense format.

This is the table retrieved by NPrinting

NPrinting is not retrieving the format of columns Units v LW and Wks Cover TW.

I greatly appreciate if you have any idea of how to solve this issue.

Regards,

John

Re: How to keep QlikSense table format in NPrinting Excel report

miskin_m — Mon, 13 Feb 2017 05:44:34 GMT

One thing you can try is drop the whole chart on excel report rather than individual fields of a table, Also I am not sure if this will work. Just give it a try.

Anyways the best option is to do formating at nprinting side rather than in qlikview.

Re: How to keep QlikSense table format in NPrinting Excel report

mayuresh_d — Mon, 13 Feb 2017 07:25:55 GMT

hi,

as the format you used in qlikview will not work in nprinting there u need to have to give proper format again.

i hope this will help

Re: How to keep QlikSense table format in NPrinting Excel report

Anonymous — Mon, 13 Feb 2017 21:02:51 GMT

Many thanks for all your answers. I will definitely repeat the format again in Nprinting.

Regards,

John