Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
paula1604
Contributor
Contributor

Cumulative line graph.

Hi! I need help 😞 I'm new on Qlik sense. I have a cumulative line graph about a measure and it has dates per day of a year. I want to know if its possible to pick a period of time (example may to september) and show the same cumulative graph just for the interval.

I tried in many different forms, but always  the cumulative line start to sum from may, and i want it to keep the values of cumulative sum from january.

1 Reply
mayuringale25
Partner - Creator
Partner - Creator

Hi @paula1604 

Add your Month values as dimension and for the measure use this expression

aggr(rangesum( above( sum([MEASURE_NAME]),0,rowno())),Month)

 

Thanks and Regards
Mayur Ingale