Fornightly Moving Average

Anonymous — Wed, 12 Sep 2018 22:25:31 GMT

Well, I need to create an expression that calculates a fornightly moving average.

I'm attaching an Excel file with the data I have in another Excel file and the data I have in one pivot table in Qlikview.

I need to calculate the moving average for every single day using the data I have from the latest ten days in the "Tasa Otros" column (expression).
I have used this formula:

RangeAvg(Above("Tasa Otros",0,10))

but the result is wrong.

I created my pivot table with three dimensions: Año (Year), Mes (Month) and Día (Day)

But for holidays and weekends, the value for "Tasa Otros" is null.

So I used the next formula:

IF(IsNull("Tasa Otros"),null(),RangeAvg(Above("Tasa Otros",0,10)))

but, it didn't work too.

Please, help me!!!

Hope you'll understand what I'm asking for

Re: Fornightly Moving Average

BalaBhaskar_Qlik — Thu, 13 Sep 2018 08:41:40 GMT

Try this:

=RangeAvg(Above(Count("Tasa Otros"),0,10))

Re: Fornightly Moving Average

BalaBhaskar_Qlik — Thu, 13 Sep 2018 08:42:13 GMT

Delete this duplicate thread.

=IF(IsNull("Tasa Otros"),null(),RangeAvg(Above(Count("Tasa Otros"),0,rowno())))

topic Re: Fornightly Moving Average in App Development

Fornightly Moving Average

Re: Fornightly Moving Average

Re: Fornightly Moving Average