topic Rolling average in load in QlikView

Rolling average in load

sibrulotte — Fri, 05 Oct 2018 15:35:07 GMT

Hi,

I have a table with 30 days of conversion rates.

I'd like for each date to give the average of the last 5 days prior to that date. Obviously the first 4 records have no valid average to give.

Do I need to do a loop to create my final table?

sunny_talwar — Fri, 05 Oct 2018 15:37:36 GMT

Something like this should work on a sorted table

RangeAvg(Rate, Peek('Rate', -1), Peek('Rate', -2), Peek('Rate', -3), 'Peek('Rate', -4)) as Rolling5DayAverageRate

QlikNoviceNo1 — Fri, 05 Oct 2018 16:15:42 GMT

Hi Simon,

Did you happen to refer this post? I think it should be helpful.

Thanks