Discussion Board for collaboration on QlikView Scripting.
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.
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
Try this for the last expression
RangeSum(Column(1), -RangeSum(Above(Count(DISTINCT Zertifizierte_NB), 0, RowNo())))
View solution in original post
Thank you! That is exactly what I was looking for.