Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
1.what is rolling n months?
2.what is the application of rolling n months?
3.please provide me some examples?
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
how to write expression for it
=Sum({<MonthYear = {">=$(=Date(MonthStart(Min(MonthYear), -GetSelectedCount(MonthYear)), 'MMM-YYYY'))<=$(=Date(MonthStart(Max(MonthYear), -GetSelectedCount(MonthYear)), 'MMM-YYYY'))"}>}Sales)
hi
You can implement https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130
and
hope this helps you
Vikas