Aggregated column as Input in Next Formula

[mmainiero]

Hi,

I have following problem:

I would like to use the accumulated Result in "Zert" (see picture) and subtract it from "Alle" . Unfortunately Qlikview doesn’t uses the aggregated value in each row rather the simple formula result.

In “Zert” I would like have accumulate each month to the next and so on.

Regards,

In Zert as example I would like to have:

Month      Alle                       Zert         Alle-Zert

1                600                     5              565

2                605                    12            593 

3                612                    21            591

Month 2 Zert is Count(Zert) Month 1 + Month 2

Month 3 Zert is Count(Zert) Month 1 + Month 2 + Month 3

...

[sunny_talwar · Accepted solution]

Try this for the last expression

RangeSum(Column(1), -RangeSum(Above(Count(DISTINCT Zertifizierte_NB), 0, RowNo())))

[mmainiero]

Thank you! That is exactly what I was looking for.