topic Re: Formula in Excel Nprinting not Working in Qlik NPrinting

Formula in Excel Nprinting not Working

Qlikuser09 — Thu, 02 Nov 2023 13:10:33 GMT

I have this formula in "Date(Max({$<[Pay Period Record]={2}>} [Pay Period End Date]), 'YYYY-MM-DD')" which gives me an exact date , but when I try to add in this in nprinting Formula tab , it is giving me 45660 number

Re: Formula in Excel Nprinting not Working

David_Friend — Thu, 02 Nov 2023 14:35:26 GMT

@Qlikuser09 here is the help documentation:
https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/ExcelReports/Intro-Excel.htm

Have you checked the 'keep source format' box in NP Designer?

https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/ReportsDevelopment/Designer-properties.htm#:~:text=contains%20the%20object.-,Keep%20Source%20Formats,Keep%20Source%20Formats%20check%20box.

Re: Formula in Excel Nprinting not Working

Aurelien_Martinez — Thu, 02 Nov 2023 14:37:50 GMT

Hi,

Text(Date(Max({$<[Pay Period Record]={2}>} [Pay Period End Date]), 'YYYY-MM-DD'))

Aurélien

Re: Formula in Excel Nprinting not Working

Frank_S — Thu, 02 Nov 2023 19:06:44 GMT

Ensure to always test your expressions by inserting them into Qlik Text box in your Qlik Application before using with NPrinting.
The formula shared by @Aurelien_Martinez seem accurate and should convert your text values to date format.

Re: Formula in Excel Nprinting not Working

Lech_Miszkiewicz — Thu, 02 Nov 2023 22:13:51 GMT

Hi @Qlikuser09

@Aurelien_Martinez provided you with one solution, another solution would be to apply excel cell custom date format using excel number formatting. which will display numerical value as date.

cheers