Skip to main content
Announcements
Qlik Launches Open Lakehouse and advanced agentic AI experience in Qlik Answers! | LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
paula1604
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.

Labels (2)
1 Reply
mayuringale25
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