5 Replies Latest reply: Dec 13, 2012 5:55 AM by Martin Grape RSS

    Use dimension value in set analysis

      Hi,

       

      I am stuck on a problem that is drivning me crazy!

       

      I need to calculate the associated sales for all products.

      (sum of sales for all customers who bought the product in the dimension column)

       

      Attached is a Qlikview with data and some test that don't work. (tried several others also)

       

      Anyone know how to do this. I rather not load the sales table twice.

       

      Cheers

      Martin