Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

oehmemat
New Contributor

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
djk
Valued Contributor III

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

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.

3 Replies

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

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)

djk
Valued Contributor III

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

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
New Contributor

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

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

Community Browser