topic Re: help with rolling period calculation in QlikView

help with rolling period calculation

MarioNZ — Wed, 25 Nov 2020 16:16:04 GMT

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

MindaugasBacius — Fri, 19 Jul 2019 04:46:14 GMT

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

Attach an excel sample.

Thank you

jonathandienst — Fri, 19 Jul 2019 05:19:47 GMT

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 — Sun, 21 Jul 2019 21:24:33 GMT

Hi All,

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

THANKS!!