topic Re: 10 week average in QlikView https://community.qlik.com/t5/QlikView/10-week-average/m-p/386645#M1167503 <HTML><HEAD></HEAD><BODY><P>=AddMonths(Date, -12)</P><P>Also you can use YearToDate() to check if the date is year to date.</P></BODY></HTML> Sat, 08 Sep 2012 12:15:57 GMT whiteline 2012-09-08T12:15:57Z 10 week average https://community.qlik.com/t5/QlikView/10-week-average/m-p/386644#M1167502 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need this year average and last year average.</P><P>This year average I get with this:</P><P>=(sum({&lt;Date={'&gt;=$(=WeekStart(Max(Date), -9))&lt;=$(=Max(Date))'},Week=,Year=}Value))/10</P><P></P><P>But how can I change it that Date is the Date -1 year?</P><P>And what will happen if I select a date like 29 feb and it does not exist in the year before? </P></BODY></HTML> Fri, 07 Sep 2012 11:10:35 GMT https://community.qlik.com/t5/QlikView/10-week-average/m-p/386644#M1167502 2012-09-07T11:10:35Z Re: 10 week average https://community.qlik.com/t5/QlikView/10-week-average/m-p/386645#M1167503 <HTML><HEAD></HEAD><BODY><P>=AddMonths(Date, -12)</P><P>Also you can use YearToDate() to check if the date is year to date.</P></BODY></HTML> Sat, 08 Sep 2012 12:15:57 GMT https://community.qlik.com/t5/QlikView/10-week-average/m-p/386645#M1167503 whiteline 2012-09-08T12:15:57Z