Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculated dimension for recent 12 months

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

1 Reply
Not applicable
Author

To clarification- I'm trying with:

CalendarDate={">=$(=CalendarMonth(CalendarDate(Max(CalendarMonth)),-12))<=$(=CalendarMonth(CalendarDate(Max(CalendarMonth))))"}>}

Grtz,

Beata