# Qlik Sense App Development

New Contributor II

## cumulative sum in line graph Qlik Sense

Hello i have line graph that i want to make cumulative. My expression right now is.

IF((GETSELECTEDCOUNT(Jaar) OR GETSELECTEDCOUNT(Maand) OR GETSELECTEDCOUNT(Maandjaar) OR GETSELECTEDCOUNT(Kalenderdatum)) = 0,

SUM({\$ <`Type grootboek` = {'Resultaat'}, Maand =, periode_flag_current_year = {"<=\$(=MAX(previous_period_flag_current_year))"}, Jaar = {"\$(=MAX(Jaar))"}  >} Gerealiseerd) / 1000,

SUM({\$ <`Type grootboek` = {'Resultaat'}, Maand =, periode_flag_current_year = {"<=\$(=MAX(periode_flag_current_year))"}, Jaar = {"\$(=MAX(Jaar))"}  >} Gerealiseerd) / 1000

)

I know you need to a rangesum but can someone help me? Thanks already

1 Solution

Accepted Solutions
MVP

## Re: cumulative sum in line graph Qlik Sense

Seems to be accumulating?

6 Replies
MVP

## Re: cumulative sum in line graph Qlik Sense

May be this

RangeSum(Above(

IF((GETSELECTEDCOUNT(Jaar) OR GETSELECTEDCOUNT(Maand) OR GETSELECTEDCOUNT(Maandjaar) OR GETSELECTEDCOUNT(Kalenderdatum)) = 0,

SUM({\$ <`Type grootboek` = {'Resultaat'}, Maand =, periode_flag_current_year = {"<=\$(=MAX(previous_period_flag_current_year))"}, Jaar = {"\$(=MAX(Jaar))"}  >} Gerealiseerd) / 1000,

SUM({\$ <`Type grootboek` = {'Resultaat'}, Maand =, periode_flag_current_year = {"<=\$(=MAX(periode_flag_current_year))"}, Jaar = {"\$(=MAX(Jaar))"}  >} Gerealiseerd) / 1000

), 0, RowNo()))

New Contributor II

## Re: cumulative sum in line graph Qlik Sense

This doenst work get line from 0 back.

can someone else help?

MVP

## Re: cumulative sum in line graph Qlik Sense

Would you be able to share a sample?

New Contributor II

Attached the app

MVP

## Re: cumulative sum in line graph Qlik Sense

Seems to be accumulating?

New Contributor II

## Re: cumulative sum in line graph Qlik Sense

Im very thankfull!!

Nice weekend