Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mmainiero
Contributor II
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
sunny_talwar

Try this for the last expression

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

View solution in original post

2 Replies
sunny_talwar

Try this for the last expression

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

mmainiero
Contributor II
Contributor II
Author

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