topic Re: RangeAvg expresison syntax question in QlikView

RangeAvg expresison syntax question

jblomqvist — Wed, 02 Sep 2015 11:57:56 GMT

Hi all,

I have the following expression:

RangeAvg(Above(Sum(LineSalesAmount),0,RowNo()))

This is used in the following table:

Can anyone please explain to me what the 0 does as the above expression?

The idea of this expression is to show the average of all the rows until the current row. But I do not understand what the zero does

jonathandienst — Wed, 02 Sep 2015 12:03:01 GMT

The second parameter is an offset. 0 means include the current row (offset of 0). 1 would include everything in Above, except the current row.

jblomqvist — Wed, 02 Sep 2015 12:07:14 GMT

Hi Jonthan,

Thanks for your reply. I realised it's part of the Above function.

What does the RowNo() function do as part of that? Sorry the expression is not something I am familiar with so trying to understand