topic Set Analysis - Empty subset in QlikView

Set Analysis - Empty subset

Wed, 03 Jun 2015 06:47:27 GMT

Hi,

I am doing some basic set analyis things but I am not able to find a solution for this problem. I am just calculating a sum over a subset of the current selection:

Sum({$<Check={'Y'}>} SumField)

Basically this works fine, but when there is no value Check='Y' in the current selection, the expression calcualtes the sum of all values in SumField. How can I change this expression so it returns zero in that case?

Thanks for your help

Re: Set Analysis - Empty subset

petter — Wed, 03 Jun 2015 06:57:09 GMT

Maybe:

RangeSum(Sum({$<Check={'Y'}>} SumField),0)

Re: Set Analysis - Empty subset

Wed, 03 Jun 2015 07:04:27 GMT

Hi,

Try this:

=NumSum(Sum({$<Check={'Y'}>} SumField),0)

Re: Set Analysis - Empty subset

tresB — Wed, 03 Jun 2015 08:50:12 GMT

May be like:

Sum({$<Check * = {'Y'}>} SumField)

Re: Set Analysis - Empty subset

Wed, 03 Jun 2015 08:56:50 GMT

Try this...

if( Check = 'Y', Sum({$<Check={'Y'}>} SumField), 0)