topic counting only second scenario in QlikView

counting only second scenario

renjithpl — Wed, 31 Mar 2010 12:16:59 GMT

I have two fields A and B,

I want to say if A and B are null, then say 'no', and then if B is filled with data and if A is blank then, say 'yes'

And finally I want the count of only 'yes'

i used the below formula

=If(IsNull(A & B), 'no', Count(If(IsNull(A), 'yes')))

fyi... the first condition is must i cant ommit (If(IsNull(A & B), 'no')

But its showing the data of both no and yes.

can any one help me..

Anonymous — Wed, 31 Mar 2010 12:20:43 GMT

Could also do something like the following.


sum( If ( IsNull(A) and IsNull(B), 0, if ( IsNull(A),1) ) )

rgrds

Anita

renjithpl — Wed, 31 Mar 2010 12:33:16 GMT

hey cool dude... it works..thanks a lot

SunilChauhan — Wed, 31 Mar 2010 12:57:11 GMT

hi,

hope this will work

If(IsNull(a & b), 'no',Count(If(IsNull(a), -1,'yes')))

gud luck