6 Replies Latest reply: Sep 1, 2016 7:25 AM by srivastalan s

# Is it possible to create a cumulative sum line graph in Qlik?

HI guys,

The only option available that comes close is a line graph. Is there a hidden option that I'm unaware of, a plugin to support cumulative line graphs, or is it impossible to use a cumulative sum graph in Qlik?

Thanks

• ###### Re: Is it possible to create a cumulative sum line graph in Qlik?

You can use RangeSum(Above()) function to create cumulative chart in Qlik Sense

• ###### Re: Is it possible to create a cumulative sum line graph in Qlik?

Can that function be used with an existing line graph chart to trasnform it?

• ###### Re: Is it possible to create a cumulative sum line graph in Qlik?

I believe you should be able to. Do you have a sample you can share?

• ###### Re: Is it possible to create a cumulative sum line graph in Qlik?

Right now, all I have in an expression for the chart is Sum([finish]-[start])

Placing the function you recommended under the first line doesn't work. Apologies for my lack of understanding, I'm pretty new with Qlik.

Currently it's:

Sum([finish]-[start])

RangeSum(Above())

Thanks.

• ###### Re: Is it possible to create a cumulative sum line graph in Qlik?

May be try like this

RangeSum(Above(TOTAL Sum([finish]-[start]), 0, RowNo(TOTAL)))

or

RangeSum(Above(Sum([finish]-[start]), 0, RowNo()))

• ###### Re: Is it possible to create a cumulative sum line graph in Qlik?

Hi Zeeshan,

You can use Rangesum(Above(Sum([finish]-[start]),0,Rowno())) in your expression.

For better view, you can enable Continuous option in Axes in Line chart properties.