3 Replies Latest reply: Mar 6, 2018 7:34 AM by Jonathan Dienst RSS

    Concatenate 3 fields to 1 row - Qlikview

    ruti t

      Hi everyone.

       

      I want to unite 3 fields to one row.

       

      For example :

       

      I have the following 3 fields:

       

      ID1ID2ID3
      114411
      225522
      336644

       

      I want that after the calculated I will get 1 row with all the united values:


       

      ID
      11
      22
      33
      44
      55
      66


      I prefer the calculated will be in the edit expression and not in the script...


      Any advise?


      Than you!

      Ruti.