# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save \$300 before February 6: REGISTER NOW!
cancel
Showing results 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
MVP

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

Not applicable
Author

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

MVP

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.

MVP

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.

Contributor II

Thank you Sunny! Your solution works perfectly.

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?

 Month(2019) Monthly count Expected Cumm Count 2018 total 4,000,000 4,000,000 01 100,050 4,100,051 02 85,696 4,185,749 03 88,769 4,274,521 04 90,912 4,365,437 05 101,847 4,467,289 06 101,577 4,568,872 07 111,278 4,680,157 08 35,009 4,715,174

Thanks

Tags
Community Browser