A table in PixelPerfect is showing dates in numerich 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
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.