5 Replies Latest reply: Dec 8, 2016 7:03 AM by Dhanashri Dindore RSS

    HOW TO CONCAT FIELDS?

    pradnya nemade

      Hi,

       

      I am new to Qlik Sense and need help on below issue urgently.

       

      I have a Table as follows:

       

      I have field names Product Name in which there are different Products :

      Product Name

      S1

      S2

      S3

      S4

      S5

      S6

       

      CustidProduct Name
      1S1
      1S2
      2S3
      2S1

       

      and i am looking for output like:-

       

      CustidProducts bought
      Products not bought
      1S1,S2S3,S4,S5,S6
      2S3,S1S2,S4,S5,S6

       

      Actually in the Output of Products not bought I want all product name which are not bought by the Customer and they must be comma seperated.