3 Replies Latest reply: Aug 21, 2017 2:22 AM by Anil Samineni 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...




      Fabrizio Giorgio