# 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

Tags (2)
7 Replies
MVP

## 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?

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

MVP

## 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.

MVP

## 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.

New Contributor

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

Thank you Sunny! Your solution works perfectly.

Community Browser