topic Re: NP 17.3: PixelPerfect and Date Format in Qlik NPrinting

NP 17.3: PixelPerfect and Date Format

Danijel — Thu, 20 Jul 2017 07:04:10 GMT

Hello,

i have one problem with date formats in my PixelPerfect Report.

Based on my QV Document i'am generating a table. Here i'am using two date fields. (Formatted in Script -> date(FieldA,'DD.MM.YYYY').

On Report at NPrinting i see the dates only as numbers eg. 42923.. When i try to format this value in Designer with -> DateTimes -> "dd.MM.yyyy" i get only values like "dd42923mmyyyy"?!

Can someone help me?

Thanks.

Greetings.

Re: NP 17.3: PixelPerfect and Date Format

techvarun — Thu, 20 Jul 2017 07:37:24 GMT

I tried Date(datefield) in script and the result coming perfect.

am i got your issue correctly?

Re: NP 17.3: PixelPerfect and Date Format

Danijel — Thu, 20 Jul 2017 07:53:23 GMT

Yes you are right. but unfortunately it seems like you tried it with NP < 17 right? I trink i could be a bug in 17..

Re: NP 17.3: PixelPerfect and Date Format

techvarun — Thu, 20 Jul 2017 07:56:25 GMT

I am using 16.2.0.0 (SR2)

Re: NP 17.3: PixelPerfect and Date Format

Lech_Miszkiewicz — Fri, 21 Jul 2017 00:43:39 GMT

Hi,

It looks like bug as formatting works well for numbers and other formats and doesn't for dates. I worked it around by applying source formatting on Qlik document like Text(Date(MyDateField,'DD.MM.YYYY')) and i did not to have to apply PixelPerfect formatting at all then. I am aware that this is just workaround and it makes Qlik development much harder, but for NPrinting i am always using dedicated document so i did not bother.

cheers

Lech

Re: NP 17.3: PixelPerfect and Date Format

Danijel — Fri, 21 Jul 2017 06:09:16 GMT

Hey Lech,

Interesting idea. Which I could still find, if i use the fields from a level i get the false format, if i use the fields from a table (same fields!) i get the right format....?!

greetings

Re: NP 17.3: PixelPerfect and Date Format

Lech_Miszkiewicz — Fri, 21 Jul 2017 06:13:38 GMT

I used it in both places (Level just as a field from data model) and table - as a dimension (without any formatting) and it worked with QV 12.1 and NPrinting June 2017.

regards

Lech

Re: NP 17.3: PixelPerfect and Date Format

paul8pharma — Fri, 05 Jul 2019 07:55:13 GMT

I'm on the April 2019 version (19.9.5.0) of Nprinting and this "bug" appears to still be a problem in PixelPerfect. Quite the PITA.

Has anyone got any workarounds that don't require large change Qlikview sheet?

Re: NP 17.3: PixelPerfect and Date Format

Frank_S — Mon, 08 Jul 2019 18:14:23 GMT

Have a look at this solution and if it applies to your scenario.

I tested it recently and it works perfectly.

https://support.qlik.com/articles/000034881

Re: NP 17.3: PixelPerfect and Date Format

paul8pharma — Tue, 09 Jul 2019 13:26:00 GMT

It does, and it has worked for me!

Thanks!