Rolling n months

[sekharapp]

1.what is rolling n months?

2.what is the application of rolling n months?

3.please provide me some examples?

[abhijitnalekar]

Hi @sekharapp ,

1. Rolling N month is the number of months trend that users want to analyze. 

Eg. If the user asks to show the 12 rolling month data on a chart then he wants the last 12 months' data from today's date

means Jun 2021 to Jun 2022

[sekharapp]

how to write expression for it

[abhijitnalekar]

=Sum({<MonthYear = {">=$(=Date(MonthStart(Min(MonthYear), -GetSelectedCount(MonthYear)), 'MMM-YYYY'))<=$(=Date(MonthStart(Max(MonthYear), -GetSelectedCount(MonthYear)), 'MMM-YYYY'))"}>}Sales)

[vikasmahajan]

hi

You can implement https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

and 

https://community.qlik.com/t5/App-Development/YTD-MTD-QTD-Rolling-3-Rolling-12-months-in-filter-pane...

hope this helps you

Vikas