Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

excluding rows in rangesum

Hello

Is there a way to exclude rows in the rangesum function?

I can walk on water when it freezes
9 Replies
tresesco
MVP
MVP

No such parameter to pass in rangesum(). But, may be an alternate way could help. Create a qvw with sample data and explain the expected output there.

ali_hijazi
Partner - Master II
Partner - Master II
Author

the detailed question is on the following thread:

range sum question

I can walk on water when it freezes
tresesco
MVP
MVP

Best way to be helped in such cases to create a sample qvw. Feeling lazy to create my own.

ali_hijazi
Partner - Master II
Partner - Master II
Author

check attached document please

I can walk on water when it freezes
ali_hijazi
Partner - Master II
Partner - Master II
Author

check attached document on the following link

excluding rows in rangesum

I can walk on water when it freezes
tresesco
MVP
MVP

=If( RowNo()=1,Above( total Top(b))+b, RangeSum(Above( b,0,RowNo())))

PFA

Hope this is what you wanted. Even I am happy to get the solution the way I got (Intially for a second it came in mind that, 'it might not be possible', but then...!!) . Thanks, for the requirement.

ali_hijazi
Partner - Master II
Partner - Master II
Author

no it's not correct

I tried solving it by script and used the previous function in the load statement after sorting by release and fix period

the result on period 3 should be 184 and not 163 as your solution

I can walk on water when it freezes
tresesco
MVP
MVP

Try:

=If( RowNo()=1,RangeSum(Above( total Top([Your Result])),b), RangeSum(Above( b,0,RowNo())))

ali_hijazi
Partner - Master II
Partner - Master II
Author

I solved it in the script

I can walk on water when it freezes