Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
sunny_talwar

Seems to be accumulating?

Capture.PNG

View solution in original post

6 Replies
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
Not applicable
Author

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
Not applicable
Author

Attached the app

sunny_talwar

Seems to be accumulating?

Capture.PNG

Anonymous
Not applicable
Author

Im very thankfull!!

Nice weekend