Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
=RangeAvg(Above(Count("Tasa Otros"),0,10))
Delete this duplicate thread.
=IF(IsNull("Tasa Otros"),null(),RangeAvg(Above(Count("Tasa Otros"),0,rowno())))