Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
John_SM
Contributor III
Contributor III

Running Total kind of...

Hello, I would need some in calculating a running total.

Monthname(Date) Product Start of month Balance sum(sales) sum(payout) End of month Balance
Jan-22 A 0 100 0 0 + 100 - 0 = 100
Feb-22 A 100 150 50 100 + 150 - 50 = 200
Mar-22 A 200 50 200 200 + 50 - 200 = 50
           
Jan-22 B 0 200 0 200
Feb-22 B 200 50 100 200 + 50 - 100 = 150
Mar-22 B 150 100 50  
Apr-22 B   80 50  


I have a dataset with Date, Sales and Payout. I want to calculate on a product level (with date of course). I will have for each product at the start of the first month has 0 sales at first then we add the sales of that month and then we substract the payout. This new value will be the starting value of the next month and so on. Can you anyone help me? I tried with above/rangesum but I didn't get the expected values

Labels (1)
1 Reply
John_SM
Contributor III
Contributor III
Author

Any help would be appreciated