Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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

7 Replies

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

Not applicable

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

Thanks for your reply.


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?

Not applicable

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()))

Not applicable

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.

miranast
New Contributor

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

Thank you Sunny! Your solution works perfectly.