topic Re: Need to create Rolling 12 months chart. in App Development

Need to create Rolling 12 months chart.

sharu055 — Tue, 29 Mar 2022 11:28:07 GMT

I am having Month_ Year, Manager and User ID column. I need to count the User ID of managers in 12 months rolling. My dimensions would be Year_Month and Manager and expression is Count(User ID). How should i achieve in my Qlikview line chart. I have data from 2021 amd 2022.

Re: Need to create Rolling 12 months chart.

anat — Wed, 30 Mar 2022 13:46:39 GMT

Sum({$< [YearMonth]={'>=$(=Monthstart(Addmonths(Max([YearMonth]),-11)))<=$(=Max([YearMonth]))'} >}sal)

https://community.qlik.com/t5/QlikView-Documents/Calculating-rolling-n-period-totals-averages-or-other/ta-p/1483033