help with rolling period calculation

[MarioNZ]

Hi All,

I'm trying to do a pretty straight forward rolling period calculation in Qlikview - at least it's pretty easy to do in Excel

I'm calculating a rolling 4 week period - as per the below -  the percentages are the answer i'm trying to achieve

i.e - after the completion of  previous week, sum(last 4 weeks)/4

Saturday
	0%
	0%
	0%
1	25%
	25%
1	50%
	50%
1	50%
1	75%
1	75%
	75%
	50%
	25%
	0%
1	25%
1	50%
1	75%
	75%	COUNT(CD38:CD41)/4
	50%
	25%
	0%
	0%
1	25%
	25%
	25%
	25%
1	25%
	25%
1	50%
1	75%
1	75%
1	100%
1	100%
1	100%
	75%
	50%
	25%
	0%
	0%
	0%
	0%
	0%
1	25%
1	50%
1	75%
1	100%
	75%

[MindaugasBacius]

Please provide detailed calculations as for us it isn't straight forward rolling period calculation 🙂

Attach an excel sample.

Thank you

[jonathandienst · Accepted solution]

I'm not sure what the dimensions of the table are or what the field Saturday represents, so this is  guess, but perhaps something like:

RangeAvg(Above(Sum(Saturday), 0, 4))

[MarioNZ · Accepted solution]

Hi All,

I've used the "Accumulate 4 steps back" function and it seems to work perfectly...

THANKS!!