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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
felcar2013
Partner - Creator III
Partner - Creator III

how to display last 12 cumulative months from a time series

Hi

I am getting stucked here, I want to display the last 12 months from the selected month, The selected month is in this case Aug 2016. I Need to Display the cumulated values as shown in the figure, i.e., not taking Sep 2015 as the first month to start the cumulation, but using always Jan 2015 as first month of the cumulation.

Any ideas on how to show the Chart in this form, without loosing the cumulative values ?

thanks

PD: $(vL.ToMonth) = max(%date_monthyear__id)

$(vL.FromMonth) = $(vL.FromMonth) -12

the Formula Looks like this:

=sum({$<date_year=,date_monthyear=,date_month=, %date_monthyear__id={">=$(=min({1}%date_monthyear__id))<=$(vL.FromMonth)"} >}registrations_sum)
+
rangesum(Above( sum({$<date_year=,date_monthyear=,date_month=, %date_monthyear__id={">$(vL.FromMonth)<=$(vL.ToMonth)"} >}registrations_sum) ,0,Rowno())) 

2 Replies
vinieme12
Champion III
Champion III

Accumulative Sums

Also search the community for Rolling Total, there is lot of content available

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
felcar2013
Partner - Creator III
Partner - Creator III
Author

thanks