Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
Partner
Partner

NP 17.3: PixelPerfect and Date Format

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.

2 Solutions

Accepted Solutions

Re: NP 17.3: PixelPerfect and Date Format

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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

Highlighted
Support
Support

Re: NP 17.3: PixelPerfect and Date Format

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

We are just 'like' you & like to be liked when we provide a helpful answer and or when you press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!

View solution in original post

9 Replies
Highlighted
techvarun
Valued Contributor II

Re: NP 17.3: PixelPerfect and Date Format

sample.PNG

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

am i got your issue correctly?

Highlighted
Partner
Partner

Re: NP 17.3: PixelPerfect and Date Format

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

Highlighted
techvarun
Valued Contributor II

Re: NP 17.3: PixelPerfect and Date Format

I am using 16.2.0.0 (SR2)

Re: NP 17.3: PixelPerfect and Date Format

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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

Highlighted
Partner
Partner

Re: NP 17.3: PixelPerfect and Date Format

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

Highlighted

Re: NP 17.3: PixelPerfect and Date Format

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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Highlighted
paul8pharma
New Contributor II

Re: NP 17.3: PixelPerfect and Date Format

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?

Highlighted
Support
Support

Re: NP 17.3: PixelPerfect and Date Format

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

We are just 'like' you & like to be liked when we provide a helpful answer and or when you press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!

View solution in original post

Highlighted
paul8pharma
New Contributor II

Re: NP 17.3: PixelPerfect and Date Format

It does, and it has worked for me!

 

Thanks!