0 Replies Latest reply: Mar 11, 2013 6:55 AM by odiaconu RSS

    aggregation in qlikview

      Hi,

      I am having some information about sales at SKU level (product), Store where it was sold and date.

      I want to be able to aggregate all sales per Store and per day and than divide the SKU/Store/Data information to the total sales per Store/Day.

      My loading script looks like this:

       

      Directory;

      LOAD

           POC.DATE,

           POC.Store_CODE,

           POC.SKU,

           POC.Sales 

      FROM

      [C:\My Program Files\#01 - Backup QVD\201209MDA001.QVD]

      (qvd);