Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
RangeSum(Above(SUM(Expression1),0,ROWNO()))
RangeSum(Above(SUM(Expression1),0,ROWNO()))
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.
That's what I have been missing