Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi to all,
I would like to accumulate sales value for range of unique custids,
for example one customer have sales in multiple dates, need to accumulate for each customer.sample data attached , please suggest.
Thanks
If you're just looking to aggregate by customer you can do it with the following data load script. Any reason you wouldn't just let Qlik Sense do this on its own when serving up the content? If your use case is to show the total or running total on the same line in your charts there are set analysis ways to handle this.
table1:
LOAD * INLINE [
CustID,Date,Sales,Transaction Type
101,1-Jan-2019,100,B
101,2-Jan-2019,200,B
101,3-Jan-2019,300,S
101,4-Jan-2019,400,B
102,1-Jan-2019,400,B
102,2-Jan-2019,500,S
102,3-Jan-2019,600,B
102,4-Jan-2019,700,B
];
Accumulation:
LOAD CustID, SUM(Sales) as AggSales
Resident table1
GROUP BY CustID;
Yields: