topic Re: Data format in Nprinting in Qlik NPrinting

Data format in Nprinting

sylvain_piccarreta — Sat, 16 Nov 2024 04:10:18 GMT

Hello,

I need help for nprinting 17. I create a table comining from Qlikview in powerpoint in table format. But, I disable "Keep format sources" and I need to indicate for some columns a format in date.

I don't find what I need to write in the row format to have it. So, In powerpoint, I have the date in numeric froamt like 46358,12

could you help me please ?

Thanks,

Regards,

Sylvain

Thanks

Re: Data format in Nprinting

Ruggero_Piccoli — Thu, 14 Mar 2019 14:52:28 GMT

Hi,

Remove the Keep Source Format for the column with the date and in the new Format property insert a correct syntax as explained in https://help.qlik.com/en-US/nprinting/February2019/Content/NPrinting/ReportsDevelopment/Which-Formats-Columns.htm.

Qlik NPrinting will apply the formatting rule to the generated reports.

Best Regards,

Ruggero

Re: Data format in Nprinting

sylvain_piccarreta — Thu, 14 Mar 2019 15:34:50 GMT

thanks,

but it doesn't fit :

but in powerpoint, I always have the date in format 43514,69

my Nprinting version : Qlik NPrinting June 2018

Version : 18.19.6.0

thanks again for your help

Re: Data format in Nprinting

sylvain_piccarreta — Thu, 14 Mar 2019 15:35:41 GMT

even if I put format DD/MM/YYYY

Re: Data format in Nprinting

Ruggero_Piccoli — Thu, 14 Mar 2019 15:44:54 GMT

Hi,

First insert the Format and only after drag and drop the column tag in the PowerPoint template.

If you change the Format you must delete the old tag and drag and drop it again.

Another completely different alternative is to create a new column in the QlikView document that exported the date formatted as text. For example by using the formula =text(date(OrderDate,'YYYY-MM-DD')).

Best Regards,

Ruggero

Re: Data format in Nprinting

sylvain_piccarreta — Fri, 15 Mar 2019 06:57:02 GMT

it missed to me the "drag and drop" action to do.

Many thanks,

regards

Sylvain