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

rangesum(above(Sum(FIELD),0,rowno())) creates an extra unnecessary row.

For accumulated sums, I used  rangesum(above(Sum(FIELD),0,rowno()))

Then, the last row has extra space, and how can I take out  the redundant calculation? 

Capture.PNG

With the same sense,  rangesum(before(Sum(FIELD),0,ColumnNo())) creates the unnecessary extra column. How to remove it?

Labels (3)
2 Replies
anat
Master
Master

can u try like :rangesum(above(Sum(FIELD),0,12))

nezuko_kamado
Creator
Creator
Author

Thank you but It's still same showing extra row, and not working...