Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

8 Replies
sunny_talwar

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

Not applicable
Author

Thanks for your reply.


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

sunny_talwar

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

Not applicable
Author

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.

sunny_talwar

May be try like this

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

or

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

Not applicable
Author

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
Contributor II
Contributor II

Thank you Sunny! Your solution works perfectly.

sulaimon
Contributor
Contributor

Hi Sunny,

Is it possible for the cumulative chart to start from a particular Number or point?

The chart below is for 2019 and show the cumulative sum from Jan 2019, is it possible to start the cumulative from the end of 2018?

What i mean is, as of Dec 2018, the cumulative/total sum was 4,000,000 and in Jan 2019 100k was added. can the chart be changed to start the 2019 chart from 4,100,000 and continue like that using the 2018 total as the starting number?cumm chart.png

Month(2019)Monthly countExpected Cumm Count
2018 total4,000,0004,000,000
01100,0504,100,051
0285,6964,185,749
0388,7694,274,521
0490,9124,365,437
05101,8474,467,289
06101,5774,568,872
07111,2784,680,157
0835,0094,715,174

 

Thanks