Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
mmainiero
New Contributor II

Aggregated column as Input in Next Formula

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

...

1 Solution

Accepted Solutions
Highlighted

Re: Aggregated column as Input in Next Formula

Try this for the last expression

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

View solution in original post

2 Replies
Highlighted

Re: Aggregated column as Input in Next Formula

Try this for the last expression

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

View solution in original post

Highlighted
mmainiero
New Contributor II

Re: Aggregated column as Input in Next Formula

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