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

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

oehmemat — Tue, 01 Dec 2015 15:11:32 GMT

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

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

settu_periasamy — Tue, 01 Dec 2015 17:35:35 GMT

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)

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

Daniel_Jenkins — Wed, 02 Dec 2015 05:45:08 GMT

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.

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

oehmemat — Wed, 02 Dec 2015 09:49:09 GMT

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