Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
hamzabob1
Partner - Contributor III
Partner - Contributor III

Cumulative sum in qlik Sense expression

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:

AA.PNG

output Required:

B.PNG

 

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

@sunny_talwar 

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

 

Thanks.

Hamza

2 Replies
Ksrinivasan
Specialist
Specialist

hi,

you can rearrange column order,

first material code then date,

 

ksrinivasan

hamzabob1
Partner - Contributor III
Partner - Contributor III
Author

Hi vasan,

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

 

Regards,

Hamza