topic Four Week Average at Script Level in QlikView

Four Week Average at Script Level

Sun, 14 Oct 2012 10:13:52 GMT

Here is the file.

Gysbert_Wassenaar — Sun, 14 Oct 2012 10:33:26 GMT

You have to aggragate per week first. Try this:

temp1:

LOAD

[Fiscal Week Ending] ,

sum([Sales Out $]) as Sales

from US.xls (biff, embedded labels, table is "Sheet 1$") group by [Fiscal Week Ending];

final:

load *,

Rangesum(Sales,peek(Sales,-1),peek(Sales,-2),peek(Sales,-3))as myRollingAvg

Resident temp1;

drop table temp1;

Sun, 14 Oct 2012 11:01:58 GMT

Thanks Gysbert. It Works.

Working, was not concentrating on the repitition of data, my mistake.

Regards

Nassar