Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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