topic Re: Variables and Formulas no longer formatted as Date on Excel with nPrinting June 2020 in Qlik NPrinting

Variables and Formulas no longer formatted as Date on Excel with nPrinting June 2020

er77 — Thu, 11 Jun 2020 20:53:18 GMT

All,

I discovered today after I updated yesterday our nPrinting to June 2020 that on all excel reports we have, where there is a date as variable or formula, also if on Excel I force date format, when report is generated, the cell is general format and then date is showed as a string (numbers) instead of date format.

Data are pulled from Qlik Sense!

I spent 2 hours today to fix all reports adding text() before date field.

Sounds like a bug with the new version?

Re: Variables and Formulas no longer formatted as Date on Excel with nPrinting June 2020

Lech_Miszkiewicz — Thu, 11 Jun 2020 21:28:10 GMT

Thanks for that insight - I am going to test this today and follow up.

regarding: "I spent 2 hours today to fix all reports adding text() before date field'

I assume those object are only used in NPrinting and are not used for sorting etc... as adding text() would obviously screw sorting capabilities and all possible dates related formulas...

Re: Variables and Formulas no longer formatted as Date on Excel with nPrinting June 2020

Lech_Miszkiewicz — Fri, 12 Jun 2020 02:00:28 GMT

Hi @er77

I am confirming that I experienced the same behaviour after upgrade. This is quite a big change as it will require review of all reports built across all clients who decide to upgrade.

I have opened a Qlik support ticket: "02006503 - NPRINTING JUNE 2020: CHANGES DATES TO NUMBERS"

Reporting this also to: @Ruggero_Piccoli

thanks

Lech

Re: Variables and Formulas no longer formatted as Date on Excel with nPrinting June 2020

johnh — Fri, 12 Jun 2020 07:19:48 GMT

Hi There,

I came across something similar in both Qlik Sense April 2020 and QlikView April 2020

I logged it with Support as 01982209 - IN QLIK APRIL 2020 - NPRINTING HANDLES DATES DIFFERENTLY and I see the ticket has been updated to indicate that this is a bug: QV-20513

It looks more like an issue with the way the QIX Engine is handling the dual field of date.

I had a site with loads of reports and we rolled them back to a previous version of QlikView & QlikNprinting. (They estimated that it would take at least a week to modify and test all the reports)

I have another site also with lots of reports that use dates and they are not going to upgrade until this issue is sorted out.

Re: Variables and Formulas no longer formatted as Date on Excel with nPrinting June 2020

Lech_Miszkiewicz — Fri, 12 Jun 2020 08:04:59 GMT

@johnh

this is different scenario - fields behave as they should. The issue is with NPrinting formulas and variables

Re: Variables and Formulas no longer formatted as Date on Excel with nPrinting June 2020

er77 — Fri, 12 Jun 2020 08:32:08 GMT

Correct, this is something related with nPrinting inside the Designer.

No way to have cells formatted as dates like before, when I'm using Variables and/or Formulas.

text() is a workaround but unfortunately Date format was a great option because following user excel language for month/weekday translations.

Please fix!

Re: Variables and Formulas no longer formatted as Date on Excel with nPrinting June 2020

er77 — Fri, 12 Jun 2020 08:44:21 GMT

Yes, they are used on a static cell to show the Last Updated Date.

So no impact on tables

Re: Variables and Formulas no longer formatted as Date on Excel with nPrinting June 2020

robert_mika — Mon, 22 Jun 2020 16:29:02 GMT

Same here.

Lech,

Have you had any updates?

Re: Variables and Formulas no longer formatted as Date on Excel with nPrinting June 2020

Lech_Miszkiewicz — Mon, 22 Jun 2020 22:07:06 GMT

Support replicated the issue. Case is with R&D

Re: Variables and Formulas no longer formatted as Date on Excel with nPrinting June 2020

Lech_Miszkiewicz — Tue, 23 Jun 2020 03:40:57 GMT

Update: I got response from Qlik support - Issue should be resolved in September 2020 release.

My advice is - If you heavily use variables or formulas in your reports to show dates - don't upgrade.

cheers

Lech

Re: Variables and Formulas no longer formatted as Date on Excel with nPrinting June 2020

er77 — Wed, 24 Jun 2020 07:33:42 GMT

To be honest would be nice have this resolved on a potential Patch 1 for June 2020

Re: Variables and Formulas no longer formatted as Date on Excel with nPrinting June 2020

Patricia_Silva — Fri, 24 Jul 2020 11:53:10 GMT

Hello all 😊,

I am Patricia, from Support Team.

I have just checked release notes from NPrinting June 2020 SR1 and this issue has been fixed.

I have just tested it, and I can confirm it has been fixed.

Please, find also attached the article about this issue: https://support.qlik.com/articles/000108414

Thank you all for all the information provided.

Best Regards,
Patricia Silva