Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

nielsvanzetten
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
MVP

Re: cumulative sum in line graph Qlik Sense

Seems to be accumulating?

Capture.PNG

6 Replies
MVP
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()))

nielsvanzetten
New Contributor II

Re: cumulative sum in line graph Qlik Sense

This doenst work get line from 0 back.


can someone else help?


Thanks already

MVP
MVP

Re: cumulative sum in line graph Qlik Sense

Would you be able to share a sample?

nielsvanzetten
New Contributor II

Re: cumulative sum in line graph Qlik Sense

Attached the app

MVP
MVP

Re: cumulative sum in line graph Qlik Sense

Seems to be accumulating?

Capture.PNG

nielsvanzetten
New Contributor II

Re: cumulative sum in line graph Qlik Sense

Im very thankfull!!

Nice weekend