Howdy Umesh!
I like to build my calendars with an SortID attached to each major dimension that is text based or non-numeric (Month-Year, MonthName, DayOfWeek) [NOTE: If you've kept these numeric or used a dual() or some other sort of sorting system you can skip step 1 and go straight to step 2].
Step 1:
Month-Year2:
Load Month-Year
Resident Calendar
Order by Date Descending;
Left Join (Calendar) // BECAREFUL - FOR WHATEVER REASON SOME VERSIONS OF QLIK WILL DISTINCT THE LEFT TABLE AS WELL, IF THIS HAPPENS SIMPLY DISTINCT THIS TABLE WITHOUT THE LEFT JOIN AND THEN LEFT JOIN IN A 3 STEP.
Load Distinct Month-Year
RowNo() as Month-Year_ID
Resident Month-Year2;
Drop Table Month-Year2;
Step 2:
Now in your chart you can use this equation:
Sum({1<[Month-Year_Sort] = {">=$(=(min([Month-Year_Sort])-1))<=$(=(min([Month-Year_Sort])))"}>}Sales)
The 1 gives us global data while the min[Month-Year_Sort]-1 gives you 1 month-year behind and the last min[Month-Year_Sort] gives you the cap which is your selection.
Hope this helps!
Kind regards,
Yogi Achilleos
