Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

NickHoff
Valued Contributor

Rolling Twelve Months for Previous Month

Currently I have a rolling 12 months total using the following:

=NUM(AVG({$<CalendarYear =, CalendarMonthName =,AddedOn={">=$(=addmonths(max(AddedOn),-12))  <=$(=max(AddedOn))"}>}  MonthlyTargetValue),'##')

I'd like to get the rolling twelve months from the previous month not the current month.

1 Solution

Accepted Solutions
ramoncova06
Valued Contributor III

Re: Rolling Twelve Months for Previous Month

it depends on how you date


=NUM(AVG({$<CalendarYear =, CalendarMonthName =,AddedOn={">=$(=addmonths(max(AddedOn),-12))  <=$(=monthend(max(AddedOn),-1))"}>}  MonthlyTargetValue),'##')

2 Replies
ramoncova06
Valued Contributor III

Re: Rolling Twelve Months for Previous Month

it depends on how you date


=NUM(AVG({$<CalendarYear =, CalendarMonthName =,AddedOn={">=$(=addmonths(max(AddedOn),-12))  <=$(=monthend(max(AddedOn),-1))"}>}  MonthlyTargetValue),'##')

NickHoff
Valued Contributor

Re: Rolling Twelve Months for Previous Month

monthend did it, thank you