topic Re: Average last 4 weeks in QlikView

Average last 4 weeks

Fri, 18 Apr 2014 13:31:54 GMT

Hi everyone,

i have the chart attached to this post.

In this same chart i need also to calculate for each week the average value of the last 4 weeks.

Can you please help me?

Thanks,

LB.

MK_QSL — Fri, 18 Apr 2014 13:38:32 GMT

like this?

Update : For average

Avg({<WeekID = {">=$(=Max(WeekID)-3)"}>}k)

alexandros17 — Fri, 18 Apr 2014 13:39:58 GMT

Here it is an example

Fri, 18 Apr 2014 13:45:22 GMT

Hi and thx for the answers..

but i need to see both the expression:

- sum(k)

- avg (sum(k) last 4 weeks)

MK_QSL — Fri, 18 Apr 2014 13:46:10 GMT

Add one more expression of avg with my given file

rustyfishbones — Fri, 18 Apr 2014 14:04:58 GMT

Please see the attached file

Regards

Alan