3 Replies Latest reply: Aug 21, 2017 2:22 AM by Anil Babu RSS

    Adding product quantities or product $ sales within a qlikview script

    Fabrizio Giorgio

      Hi good qlikview community people,

       

      I need to report on the sum of the quanitites and / or $ sales for all our products.

       

      so I have a "Product" table with different product codes

      Then I have a "SalesOrderLine" table with all product codes sold in different sales order numbers, including when the sales order was created, the QTYOrdered, the SellPrice... etc...

       

      What would be the best/simplest function to use to:

       

      A - Count QTY's on Sales Orders per product

      B - Sum all the sell prices

       

      Any help would be appreciated...

       

      Thanks

       

      Fabrizio Giorgio