Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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