5 Replies Latest reply: Feb 18, 2013 6:12 AM by Michael Taylor RSS

    Help concatenating product purchases

    Michael Taylor

      Hi,

       

      I am fairly new to Qlikview and struggling to come up with the correct expression.

       

      I am looking to calculate all product purchases for each customer into one string based on the order the products were purchased. i.e. A | B | C.

       

       

      CustomerID ProductPurchase Date
      1A1/1/2010
      1B1/1/2011
      1C1/1/2012
      2C1/1/2010
      2A1/1/2012

       

       

      It needs to be dynamic, which means it will update as and when selections are made relating to the product table.

       

      Many thanks in advance for any help.

       

      Michael.