This content has been marked as final. Show 8 replies
In Qlik, a field can be defined to contain dual values. This means that the field values can have both a numeric value and a textual value.
The numeric value can be retrieve by using a numeric function (such as Max); the text value can be retrieve by using a string function (such as MaxString).
This works fine if no calculation is done on the field but when you add 1 for example to the value of the dual field, I always get the numeric value (see print screen below). What instruction has to be applied to get text value 'Aug' for?