topic Cumulative sum in qlik Sense expression in App Development

Cumulative sum in qlik Sense expression

hamzabob1 — Mon, 20 Dec 2021 21:05:46 GMT

Hello Everyone,

I am trying to calculate cumulative sum in a Straight table in Qlik Sense which has 3 dimensions; Date , code and Plant.

What I want is, Quantity values should be cumulatively summed in Straight table for every day.

i am getting the desired output on code selection but i want to get the correct out put without any selection.

Current table:

output Required:

stock Logic:For 11/2/2020( First day stock+2nd day quantity)and so on.

Please suggest me any solution if anyone of you gone through the same problem.

Thanks.

Hamza

Ksrinivasan — Mon, 01 Feb 2021 14:45:25 GMT

hi,

you can rearrange column order,

first material code then date,

ksrinivasan

hamzabob1 — Tue, 02 Feb 2021 05:00:14 GMT

Hi vasan,

thanks for your rpl but customer want in this format only.

Regards,

Hamza