3 Replies Latest reply: May 22, 2014 5:43 PM by Gordon Cochrum RSS

    Combine Multiple Cell Values into One

    Niegel Leoncio



      Wondering if it's possible to combine multiple cell values in qlikview as I'll be using the cell values for a script that would need all the selected values concatenated in one line.


      Here's an example:


      TABLE      COMPANY

      1               APPLE

      1               GOOGLE

      1               MICROSOFT

      2               MACYS

      2               ROSS

      2               AMC

      3               KFC

      3               TACO BELL

      3               A&W


      I'd like to have a table that would show me:



      1               APPLE, GOOGLE, MICROSOFT

      2               MACYS, ROSS, AMC

      3               KFC, TACO BELL, A&W


      Wondering if it's possible to do.