topic Count of Null values in QlikView

Count of Null values

Tue, 27 Sep 2011 06:41:21 GMT

Dear Friends,

I would like to display the count of null values of Reason Codes, like Reason Code it may contains alpha and numeric characters.

the following expression shows hypen only. I don't know where I am making a mistake. Can any one help me.

=If(Isnull([Reason Code]),Count([Reason Code])) .

Regards

Joe

Count of Null values

SunilChauhan — Tue, 27 Sep 2011 06:47:40 GMT

hope one of below help

count( if(Isnull([Reason Code]),[Reason Code]))

count( if(Isnull([Reason Code])=-1,[Reason Code]))

count( if(Isnull([Reason Code])<>0,[Reason Code]))

count( if(len([Reason Code])=0,[Reason Code]))

Count of Null values

its_anandrjs — Tue, 27 Sep 2011 07:16:16 GMT

Hi,

You have to use some thing below

=If( Isnull ( [Reason Code] ) = -1 and [Reason Code] = 0, Count([Reason Code] ) )

Let me know about this.

Hope this helps

Rgds

Anand

Count of Null values

Tue, 27 Sep 2011 07:28:55 GMT

Hello,

Thanks for your help, I tried all the expressions in the above, but still its not working now the result is 0.

In the source Reason Code it may contain either values like alpha and numeric or no value like a empty cell.

I would like to display the count of empty cells.

Regards

Joe

Count of Null values

SunilChauhan — Tue, 27 Sep 2011 07:42:29 GMT

try this

count( if([Reason Code])=' ',[Reason Code]))

or else anand chouhan will help

Re: Count of Null values

Tue, 27 Sep 2011 08:38:56 GMT

Try this ;

SUM(IF([Reason Code]='',1,0))

Count of Null values

Anonymous — Thu, 06 Oct 2011 10:29:36 GMT

This will count both nulls and blanks:
count(if(len(trim([Reason Code]))=0,[Reason Code]))

Count of Null values

Fri, 07 Oct 2011 04:53:06 GMT

Dear Michael,

Perfect answer, now its working fine..............

Thanks a lot.

Joe