Calculating in last month data in a graph.

[joshrussin]

Trying to make a line graph that has accumulated data.

I need a way to accumulate the data for each month.

I.E.

Month          Total          Cumulative

jan               10               10

feb               7                 17

mar              3                 20

apr               4                 24

Any way I can put this on a line graph and calculate it within Qlik?

[Anil_Babu_Samineni]

Try to check Accumulative Radio button from Cumulative section. Or may be this?

Rangesum(Below(Sum(Total),0),Above(Total,1,RowNo(TOTAL)))

[Kushal_Chawda]

Rangesum(Above(total sum(Total),0,RowNo(TOTAL))

[Kushal_Chawda]

Rangesum(Above(total sum(Total),0,RowNo(TOTAL)))

[balar025]

In line chart, There is option of full accumulation in expression tab.

[joshrussin]

Here is my attached app. I don't have a variable set up for Calculating the total. I tried that and gave me a random number. The chart I am working on is the Err Graphs page.

This is what it is supposed to look like.