8 Replies Latest reply: Oct 9, 2013 12:45 PM by Stefan Wühl RSS

    Sorting Numbers as text

    Jared Papador

      I have a product number field that is alpha numeric that I would like to sort as text.  For example,

       

      Currently product 10000 would come after product 1111 because it is a larger number.  On the sort tab I am using sort alphabetically A --> Z and the product number field is stored as text.

       

      Ideally I would like Qlikview to read the numbers as letters meaning:

      0 = A

      1 = B

      2 = C

      3 = D

      and so on...

       

      Has anyone done this?