Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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