topic Need help with counting nulls in QlikView https://community.qlik.com/t5/QlikView/Need-help-with-counting-nulls/m-p/1091244#M523384 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I would like to display the count of null values of Account Number.</P><P>What is the expression to calculate that.</P></BODY></HTML> Wed, 16 Mar 2016 21:22:38 GMT 2016-03-16T21:22:38Z Need help with counting nulls https://community.qlik.com/t5/QlikView/Need-help-with-counting-nulls/m-p/1091244#M523384 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I would like to display the count of null values of Account Number.</P><P>What is the expression to calculate that.</P></BODY></HTML> Wed, 16 Mar 2016 21:22:38 GMT https://community.qlik.com/t5/QlikView/Need-help-with-counting-nulls/m-p/1091244#M523384 2016-03-16T21:22:38Z Re: Need help with counting nulls https://community.qlik.com/t5/QlikView/Need-help-with-counting-nulls/m-p/1091245#M523385 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>NullCount([Account Number])</STRONG></P></BODY></HTML> Wed, 16 Mar 2016 22:18:47 GMT https://community.qlik.com/t5/QlikView/Need-help-with-counting-nulls/m-p/1091245#M523385 sunny_talwar 2016-03-16T22:18:47Z Re: Need help with counting nulls https://community.qlik.com/t5/QlikView/Need-help-with-counting-nulls/m-p/1091246#M523386 <HTML><HEAD></HEAD><BODY><P>NullCount([Account Number])</P></BODY></HTML> Thu, 17 Mar 2016 08:50:37 GMT https://community.qlik.com/t5/QlikView/Need-help-with-counting-nulls/m-p/1091246#M523386 2016-03-17T08:50:37Z Re: Need help with counting nulls https://community.qlik.com/t5/QlikView/Need-help-with-counting-nulls/m-p/1091247#M523387 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>This will count both nulls and blanks:</P><P>count(if(len(trim([Account NUmber]))=0,[Account Number]))</P></BODY></HTML> Thu, 17 Mar 2016 15:02:07 GMT https://community.qlik.com/t5/QlikView/Need-help-with-counting-nulls/m-p/1091247#M523387 nagireddy_qv 2016-03-17T15:02:07Z Re: Need help with counting nulls https://community.qlik.com/t5/QlikView/Need-help-with-counting-nulls/m-p/1091248#M523388 <HTML><HEAD></HEAD><BODY><P>Nagireddy.qv, I think you need to consider the case when [Account Number] is NULL, then your expression will count NULL which return zero. So you would need to return a value in these cases:</P><P></P><P>=count(if(len(trim([Account NUmber]))=0,'NULL'))</P><P></P><P>or</P><P>=Sum(if(len(trim([Account NUmber]))=0,1))</P></BODY></HTML> Thu, 17 Mar 2016 15:13:13 GMT https://community.qlik.com/t5/QlikView/Need-help-with-counting-nulls/m-p/1091248#M523388 swuehl 2016-03-17T15:13:13Z