Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear QlikView users,
Do you have maybe idea with which formula I can calculate dimension for last 12 months? Those I know doesn't work;( I am trying to get into moving annual total, but to do so, I need to show dimension of last 12 months (so from February 2009 to present, and that will be changing over time).
Thank you in advance,
Beata
To clarification- I'm trying with:
CalendarDate={">=$(=CalendarMonth(CalendarDate(Max(CalendarMonth)),-12))<=$(=CalendarMonth(CalendarDate(Max(CalendarMonth))))"}>}
Grtz,
Beata