topic Re: Total Count of null values in QlikView https://community.qlik.com/t5/QlikView/Total-Count-of-null-values/m-p/382944#M491022 <HTML><HEAD></HEAD><BODY><P>Thanks Whiteline,&nbsp; They were empty values therefore I used your last expression and it worked perfectly.</P></BODY></HTML> Fri, 31 Aug 2012 12:52:29 GMT 2012-08-31T12:52:29Z Total Count of null values https://community.qlik.com/t5/QlikView/Total-Count-of-null-values/m-p/382942#M491020 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a field called closedby, which usually has someones first name entered in there.&nbsp; However if a call has not been closed this fields shows as NULL.&nbsp; I want to use a text fields that gives me the full count of all rows that have a closedby showing as NULL.</P><P>How would I be able to achieve this?</P></BODY></HTML> Fri, 31 Aug 2012 11:39:51 GMT https://community.qlik.com/t5/QlikView/Total-Count-of-null-values/m-p/382942#M491020 2012-08-31T11:39:51Z Re: Total Count of null values https://community.qlik.com/t5/QlikView/Total-Count-of-null-values/m-p/382943#M491021 <HTML><HEAD></HEAD><BODY><P>If your NULL is just a string value 'NULL' (not empty value)</P><P>you can try somthing like =Count({$&lt;closedby={"NULL"}&gt;} closedby)</P><P>Create TextBox and enter this expression in a text field.</P><P></P><P>In case NULL mean empty values you can use =NullCount(closedby)</P></BODY></HTML> Fri, 31 Aug 2012 12:41:58 GMT https://community.qlik.com/t5/QlikView/Total-Count-of-null-values/m-p/382943#M491021 whiteline 2012-08-31T12:41:58Z Re: Total Count of null values https://community.qlik.com/t5/QlikView/Total-Count-of-null-values/m-p/382944#M491022 <HTML><HEAD></HEAD><BODY><P>Thanks Whiteline,&nbsp; They were empty values therefore I used your last expression and it worked perfectly.</P></BODY></HTML> Fri, 31 Aug 2012 12:52:29 GMT https://community.qlik.com/t5/QlikView/Total-Count-of-null-values/m-p/382944#M491022 2012-08-31T12:52:29Z