3 Replies Latest reply: Jul 3, 2018 3:51 AM by Richard Smith RSS

    Displaying fields as text which contains numbers

    Richard Smith

       

      We have an issue when displaying fields as text which contains numbers.

      e.g. 000023850 is loaded into a field and 023850 is loaded into the same field.

      On the reports, we want these to be displayed as 000023850 and 023850. However, they both appear as 000023850

       

      I understand why this is happening as it’s explained in the QlikSense Help…

      When several data items read into one field have different string representations but the same valid number representation, they will all share the first string representation encountered.

      We’ve tried various workarounds using string manipulation, such as adding a character before the number and then removing it when displaying it, but nothing has worked.

       

      Any help will be appreciated please.