8 Replies Latest reply: Feb 22, 2018 8:40 AM by Hedwig Vidts RSS

    Qlik sense: text value of dual field not displayed

    Hedwig Vidts

      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?

       

       

       

         Dual_function.GIF