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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read 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
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