Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can use RangeSum(Above()) function to create cumulative chart in Qlik Sense
Thanks for your reply.
Can that function be used with an existing line graph chart to trasnform it?
I believe you should be able to. Do you have a sample you can share?
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.
May be try like this
RangeSum(Above(TOTAL Sum([finish]-[start]), 0, RowNo(TOTAL)))
or
RangeSum(Above(Sum([finish]-[start]), 0, RowNo()))
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.
Thank you Sunny! Your solution works perfectly.
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