Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
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

Calculated dimension for recent 12 months

To clarification- I'm trying with:

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

Grtz,

Beata