aggregation in qlikview

Mon, 11 Mar 2013 10:55:37 GMT

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

(qvd);

topic aggregation in qlikview in QlikView