topic Re: Annual rolling Avgerage in QlikView

Annual rolling Avgerage

Thu, 24 Sep 2015 18:21:07 GMT

I know the rolling n periods topic is constantly brought up, i have read through several posts and documents. I am struggling to find a solution that will give me and Annual Average based on a rolling 36 months.

Re: Annual rolling Avgerage

Thu, 24 Sep 2015 18:29:22 GMT

try this in expression

DATE={'>=$(=AddMonths(max(DATE),-36))'}

Re: Annual rolling Avgerage

Thu, 24 Sep 2015 20:17:39 GMT

This is returning an error in the expression

Re: Annual rolling Avgerage

Thu, 24 Sep 2015 20:29:25 GMT

can you provide sample document or ur to understand well where you r applying it

Re: Annual rolling Avgerage

SreeniJD — Fri, 25 Sep 2015 04:54:35 GMT

Hi Zeth

Try this,

avg({<Date={‘>=$(=MonthStart(Max(Date), -35))<=$(=Date(Max(Date)))’}>} field_name)

HTH,

Sreeni