This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Is there a way to exclude rows in the rangesum function?
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.
the detailed question is on the following thread:
range sum question
Best way to be helped in such cases to create a sample qvw. Feeling lazy to create my own.
check attached document please
check attached document on the following link
excluding rows in rangesum
=If( RowNo()=1,Above( total Top(b))+b, RangeSum(Above( b,0,RowNo())))
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.
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
=If( RowNo()=1,RangeSum(Above( total Top([Your Result])),b), RangeSum(Above( b,0,RowNo())))
I solved it in the script