Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

10 week average

Hi,

I need this year average and last year average.

This year average I get with this:

=(sum({<Date={'>=$(=WeekStart(Max(Date), -9))<=$(=Max(Date))'},Week=,Year=}Value))/10

But how can I change it that Date is the Date -1 year?

And what will happen if I select a date like 29 feb and it does not exist in the year before?

1 Reply
whiteline
Honored Contributor II

Re: 10 week average

=AddMonths(Date, -12)

Also you can use YearToDate() to check if the date is year to date.

Community Browser