topic Re: Help with NullCount combined with If Function in QlikView

Help with NullCount combined with If Function

Wed, 06 Feb 2013 17:37:45 GMT

Hello Qlikview Community,

I would very much appreciate help with the following quandry.

I am trying to count null values in a field, with the added caveat of an If statement in another field.

To give you an idea of the data:

I would like to count the records where the 'Chargeable' field is Yes, but the 'Change Control Ref' is null, or blank.

I have tried various iterations, including the following, none of which work:

=count(if(Chargeable = 'Yes' and [Change Control Ref] > 0, CCR Reference))

=NullCount(distinct if(Chargeable = 'Yes', [Change Control Ref]))

Any ideas?

Many thanks,

Frances

pover — Wed, 06 Feb 2013 17:51:34 GMT

How about the following?

=count(if(Chargeable = 'Yes' and len([Change Control Ref]) = 0, CCR Reference))

You could use the insull() function, too, but I prefer the len() function since it treats empty cells as if they were null.

=count(if(Chargeable = 'Yes' and isnull([Change Control Ref]), CCR Reference))

Karl

Thu, 07 Feb 2013 12:45:43 GMT

Karl! You are brilliant! Thank you so much for fixing this for me

Your first option worked first time.

Frances