Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.

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