Data format in Nprinting

[sylvain_piccarreta]

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

[Ruggero_Piccoli]

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-Format...

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

Best Regards,

Ruggero

[sylvain_piccarreta]

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

[sylvain_piccarreta]

even if I put format DD/MM/YYYY

[Ruggero_Piccoli · Accepted solution]

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

[sylvain_piccarreta]

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

Many thanks,

regards

Sylvain