Fornightly Moving Average

[Anonymous]

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

swuehl‌‌ gno‌

[balabhaskarqlik]

Try this:

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

[balabhaskarqlik]

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