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

    Combine Multiple Cell Values into One

    Niegel Leoncio

      Hi,

       

      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:

       

      TABLE     COMPANY

      1               APPLE, GOOGLE, MICROSOFT

      2               MACYS, ROSS, AMC

      3               KFC, TACO BELL, A&W

       

      Wondering if it's possible to do.