1 Reply Latest reply: Jun 25, 2013 2:27 PM by Gysbert Wassenaar RSS

    Concat and sort by a column

      Hello,

       

      How to sort the concated data in an expression by a column in the same straight table ?

       

      Stated in the QlikTech Technical Brief - The CONCAT() Function:

      When using a simple concat, you have the option to add a
      sort weight to the function to order the string values by a column of your
      choice. In the example below,  the date column is used to sort the
      values…..

      =CONCAT(MyColumn, ',', Date)

       

      See the added example, it`s not working in the way I like to use it.