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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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);

Labels (1)
0 Replies