Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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
Partner - Champion III
Partner - Champion III

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