Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum of month and previous month

Hi,

I want to create a chart in which I should have the sales per month. But for example if in January I have $200 sales and in February I have $50 sales. The chart should look like January = $200 and February = $250.

In other words I want to calculate the sum of sales per month with the previous month. Finally on the last month to have the total sales amount.

Jan = $200

Feb = $50

Mar = $100

April = $70

I should have

Jan - 200

Feb - 250

Mar - 350

April - 420

Can anyone give me an idea how to do this ?

Thanks!

1 Solution

Accepted Solutions
settu_periasamy
Master III
Master III

You can try the Full Accumulation option also in Expression Tab

or Rangesum(Value,Above(Value))

View solution in original post

3 Replies
alexandros17
Partner - Champion III
Partner - Champion III

There are useful instruction like

Previous

Above

that you can use

settu_periasamy
Master III
Master III

You can try the Full Accumulation option also in Expression Tab

or Rangesum(Value,Above(Value))

Not applicable
Author

Very helpful. Thanks a lot!