Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Average last 4 weeks

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.

Tags (2)
5 Replies

Re: Average last 4 weeks

like this?

Update : For average

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

Highlighted

Re: Average last 4 weeks

Here it is an example

Not applicable

Re: Average last 4 weeks

Hi and thx for the answers..

but i need to see both the expression:

- sum(k)

- avg (sum(k) last 4 weeks)

Re: Average last 4 weeks

Add one more expression of avg with my given file

rustyfishbones
Honored Contributor II

Re: Average last 4 weeks

Please see the attached file

Regards

Alan

Community Browser