Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

(qvd);

0 Replies