topic Re: Calculating in last month data in a graph. in QlikView

Calculating in last month data in a graph.

joshrussin — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Calculating in last month data in a graph.

Anil_Babu_Samineni — Fri, 04 Aug 2017 01:32:47 GMT

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

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

Re: Calculating in last month data in a graph.

Kushal_Chawda — Fri, 04 Aug 2017 04:57:27 GMT

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

Re: Calculating in last month data in a graph.

Kushal_Chawda — Fri, 04 Aug 2017 05:03:02 GMT

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

Re: Calculating in last month data in a graph.

balar025 — Fri, 04 Aug 2017 05:03:56 GMT

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

Re: Calculating in last month data in a graph.

joshrussin — Mon, 07 Aug 2017 14:59:30 GMT

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.