topic Re: Rolling average in QlikView

Rolling average

deepakqlikview_123 — Mon, 18 May 2015 16:48:08 GMT

PFA

I have used below function for calculating rolling average for 3 consecutive rows

but my requirement is first 2 rows should be blank and average of 3 rows should be start from second row onwards.

Similiarly if i input 4 first three rows should be blank and average should displayed from fourth row onwards.

rangeavg(above(sum(sales),0,3))

Please suggest

sunny_talwar — Mon, 18 May 2015 16:55:12 GMT

Use this expression:

=If(RowNo() > 2, rangeavg(above(sum(sales),0,3)))

Anonymous — Mon, 18 May 2015 16:56:06 GMT

The RowNo() function should help you :

if ( rowno() > 2 , rangeavg(above(sum(sales),0,3)) )