Accumaltion in qlik sense script level

Anonymous — Fri, 02 Apr 2021 08:12:40 GMT

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

Re: Accumaltion in qlik sense script level

andoryuu — Mon, 09 Dec 2019 00:02:52 GMT

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:

topic Accumaltion in qlik sense script level in App Development

Accumaltion in qlik sense script level

Re: Accumaltion in qlik sense script level