cumulative sum in line graph Qlik Sense

[Anonymous]

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

[sunny_talwar]

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()))

[Anonymous]

This doenst work get line from 0 back.

can someone else help?

Thanks already

[sunny_talwar]

Would you be able to share a sample?

[Anonymous]

Attached the app

[sunny_talwar · Accepted solution]

Seems to be accumulating?

[Anonymous]

Im very thankfull!!

Nice weekend