Calculated date dimension as immediate dimension to expression in Pivot chart will lead to this error. This should be a bug in QlikView I guess.
Same set of dimensions and expressions are used in below two charts. Bar chart works fine but Pivot throws error.
Dimension: Dim1 and TransDate (Date field just tried to format =Date(TransDate, ‘MM/YY’))
Expression: Sum(Exp1), Sum(Exp2) and Sum(Exp3)
This could be resolved by changing the date format either at script level or at document UI level.
Doing it in script is pretty obvious. If you opt for document UI level modification, try below steps.
Document properties -> Number -> Select the field (TransDate) -> Give the custom format. Followed by that you have to remove the conditional dimension field and add the direct field TransDate.
That’s it, issue is resolved. 🙂
Latest Update: This bug is with 11.2 SR5 version and fixed in higher SRs.
QlikTab 