This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration on Qlik NPrinting.
in a pixel perfect report I would like to display the min and max Date of the selected values. I added the formula
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.
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
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)
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