Average of all preceding values - Page 2 - Qlik Community

Report Inappropriate Content · ‎2012-11-27

Hey!!

I would like to plot the following expression:

$z_i = \lambda \bar x_i + \left ( 1 - \lambda \right)z_{i - 1}$ .

For that I need the average of all preceding values. My dimension is a column with dates (days).

I tried: lambda*avg(L_Z1V1)+(1-lambda)*avg({1-$}L_Z1V1)

But it didn't work.

Thank you very much!!!

Eduardo

whiteline · ‎2012-11-28

=rangeavg(above(Avg(Value), 0, rowno()))

Report Inappropriate Content · ‎2012-11-28

Sorry but it still doesn't do what I need...

Thank you for your effort. I appreciate your persistance.

Eduardo