Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
d_pranskus
Partner - Creator III
Partner - Creator III

ABOVE() Function Count parameter not working

Hi

I am unable to get the ABOVE function to work with the count parameter. I have attached a sample Second expression should fully accumulate from the top. I was able to do this some time ago, probably with earlier version of QlikView, but am unable now.

Thanks

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

RangeSum(Above(SUM(Expression1),0,ROWNO()))

View solution in original post

3 Replies
MK_QSL
MVP
MVP

RangeSum(Above(SUM(Expression1),0,ROWNO()))

Gysbert_Wassenaar

If you want to accumulate you probably want to use the rangesum function. Something like:

rangesum(ABOVE(SUM(Expression1), 0, ROWNO()))

Or enable the Full Accumulation option for the expression in the Accumulation section on the Expressions tab.


talk is cheap, supply exceeds demand
d_pranskus
Partner - Creator III
Partner - Creator III
Author

That's what I have been missing