topic Re: Re: excluding rows in rangesum in QlikView

excluding rows in rangesum

ali_hijazi — Mon, 01 Sep 2014 09:27:12 GMT

Hello

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

Re: excluding rows in rangesum

tresB — Mon, 01 Sep 2014 09:32:27 GMT

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.

Re: excluding rows in rangesum

ali_hijazi — Mon, 01 Sep 2014 09:35:31 GMT

the detailed question is on the following thread:

range sum question

Re: excluding rows in rangesum

tresB — Mon, 01 Sep 2014 09:54:08 GMT

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

Re: excluding rows in rangesum

ali_hijazi — Mon, 01 Sep 2014 10:11:02 GMT

check attached document please

Re: excluding rows in rangesum

ali_hijazi — Mon, 01 Sep 2014 10:20:36 GMT

check attached document on the following link

excluding rows in rangesum

Re: Re: excluding rows in rangesum

tresB — Mon, 01 Sep 2014 10:39:34 GMT

=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.

Re: excluding rows in rangesum

ali_hijazi — Mon, 01 Sep 2014 11:29:24 GMT

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

Re: Re: excluding rows in rangesum

tresB — Mon, 01 Sep 2014 11:42:55 GMT

Try:

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

Re: Re: excluding rows in rangesum

ali_hijazi — Mon, 01 Sep 2014 14:27:11 GMT

I solved it in the script