topic Re: Compare Weekly Average with Previous Weeks Weekly average in QlikView

Compare Weekly Average with Previous Weeks Weekly average

countwise — Wed, 23 Sep 2015 14:27:41 GMT

I am new to Qlik and could do with some help. I have an expression that that returns a Weekly average for a selected period.

(Avg(Aggr(Sum(if([SensorFunction]='Mall Entrance',[Traffic], Null())),Week)))

I would like to be able to show the weekly average for the previous week.

Any help would be gratefully received

Jim

Re: Compare Weekly Average with Previous Weeks Weekly average

Gysbert_Wassenaar — Thu, 22 Oct 2015 09:38:13 GMT

Maybe like this:

Avg({<Period=,Week={'$(=Max(Week)-1))'}>}Aggr(Sum({<Period=,Week={'$(=Max(Week)-1))'},[SensorFunction]={'Mall Entrance'}>}[Traffic]),Week))

I don't know if you have a field called Period and I don't know either if your Week field contains numbers that increase by 1 for each month. You may have to adjust things accordingly.

Re: Compare Weekly Average with Previous Weeks Weekly average

countwise — Fri, 23 Oct 2015 09:04:58 GMT

Many Thanks for this, unfortunately it does not return a value.

I do have a field called Period and week numbers increase by 1 each week.

(Period has replaced month)

Any further help would be appreciated

Jim