Dates in PixelPerfect reports are shown in an incorrect format

A table in PixelPerfect is showing dates in numerical format. This may happen all the times or only sometime, when specific filters are applied. It is possible that the same table is showing dates correctly in an Excel report. This happens frequently if the field values contain both numbers and letters.

Environment

• NPrinting all versions

It is possible that Excel and PixelPerfect behave differently. In Excel each cell is evaluated separately: in the same column we can have cells evaluated as numbers  and cells evaluated as text. 
In PixelPerfect, the entire column must be evaluated at the same way. It is possible that when specific filters are applied, PixelPerfect evaluates the column as text because there are some values containing letters. With other filters, the entire column may be evaluated as numeric.

 

Sometimes it is necessary to force Qlik to pass the dates in the correct format. Generally string format works well, so the best workaround is to use the text() funcion to force  PixelPerfect to always consider the values as string.

Still need help? For further assistance with NPrinting Pixel Perfect Reports and much more, join Qlik community; Connect and learn, find answers, and discover best practices and tips and tricks.