Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
oehmemat
Contributor III
Contributor III

NPrinting Pixel Perfect: Convert Qlikview Datetime format to Dayname()

Hello community,

in a pixel perfect report I would like to display the min and max Date of the selected values. I added the formula

=dayname(max(DateTime))

and the result preview shows me the corresponding date (i.e. '31.10.2015'). But when I use the field [maxDate] in the Report it displays me the Date in the numerical qlikview format, i.e. 42307.

I already tried several ways with formatting the label as DateTime, with no luck. (it returns 'dd42307MMyyyy') and in the NPrinting Training I wasn't able to finde an example.

Before I made some Word /Excel Reports, there was no problem in displaying the values as intended.

I hope someone can help me out.

Kind Regards

Matthias

1 Solution

Accepted Solutions
Daniel_Jenkins
Specialist III
Specialist III

Hi Matthias,

Can you try creating variables in the QlikView document and then using them in the PixelPerfect report?

If you post a sample QVW file one of us can take a look. I have attached the project I used for the above. Extract to C:\Temp\Community\017

HTH - Daniel.

View solution in original post

3 Replies
settu_periasamy
Master III
Master III

Hi,

Did you check 'Keep Original Format' Checked in the NPrinting Field Preperties?

if so, did you try to change the Format in Nprinting itself (Cell properties)

Daniel_Jenkins
Specialist III
Specialist III

Hi Matthias,

Can you try creating variables in the QlikView document and then using them in the PixelPerfect report?

If you post a sample QVW file one of us can take a look. I have attached the project I used for the above. Extract to C:\Temp\Community\017

HTH - Daniel.

oehmemat
Contributor III
Contributor III
Author

Hi,

I haven't found the checkbox in PP-Reporting, only in the Office Reporting. I fiddled around with the formatting properties, but with no luck.

When I use the text()-function it's working with formulas and variables too.

Is it best practice that one has to define the DataTypes in PixelPerfect Reports?

Thank you for your help

Regards

Matthias