topic How to count nulls in QlikView https://community.qlik.com/t5/QlikView/How-to-count-nulls/m-p/212978#M66803 <HTML><HEAD></HEAD><BODY><P>Would this work for you?</P><P>=count(OrderNo) - count({$&lt;PT={"*"}&gt;} OrderNo)</P><P>Regards.</P></BODY></HTML> Fri, 03 Dec 2010 22:53:19 GMT pover 2010-12-03T22:53:19Z How to count nulls https://community.qlik.com/t5/QlikView/How-to-count-nulls/m-p/212977#M66802 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I've attached the following Document, I want to count the number nulls in a field and not sure how to do this?</P><P>Thanks</P></BODY></HTML> Fri, 03 Dec 2010 22:33:55 GMT https://community.qlik.com/t5/QlikView/How-to-count-nulls/m-p/212977#M66802 ivandrago 2010-12-03T22:33:55Z How to count nulls https://community.qlik.com/t5/QlikView/How-to-count-nulls/m-p/212978#M66803 <HTML><HEAD></HEAD><BODY><P>Would this work for you?</P><P>=count(OrderNo) - count({$&lt;PT={"*"}&gt;} OrderNo)</P><P>Regards.</P></BODY></HTML> Fri, 03 Dec 2010 22:53:19 GMT https://community.qlik.com/t5/QlikView/How-to-count-nulls/m-p/212978#M66803 pover 2010-12-03T22:53:19Z How to count nulls https://community.qlik.com/t5/QlikView/How-to-count-nulls/m-p/212979#M66804 <HTML><HEAD></HEAD><BODY><P>Or better, using Tim Benoit's blog for inspiration:</P><P>=count({$&lt;OrderNo={"=isnull(PT)"}&gt;} OrderNo)</P><P>Regards.</P></BODY></HTML> Fri, 03 Dec 2010 22:58:43 GMT https://community.qlik.com/t5/QlikView/How-to-count-nulls/m-p/212979#M66804 pover 2010-12-03T22:58:43Z How to count nulls https://community.qlik.com/t5/QlikView/How-to-count-nulls/m-p/212980#M66805 <HTML><HEAD></HEAD><BODY><P>I tried this on your example and it seemed to work:</P><P>=count(if(isnull(PT),1))</P><P></P></BODY></HTML> Fri, 03 Dec 2010 23:00:29 GMT https://community.qlik.com/t5/QlikView/How-to-count-nulls/m-p/212980#M66805 2010-12-03T23:00:29Z How to count nulls https://community.qlik.com/t5/QlikView/How-to-count-nulls/m-p/212981#M66806 <HTML><HEAD></HEAD><BODY><P>nullcount(PT) worked like a charm.</P></BODY></HTML> Fri, 03 Dec 2010 23:15:15 GMT https://community.qlik.com/t5/QlikView/How-to-count-nulls/m-p/212981#M66806 2010-12-03T23:15:15Z How to count nulls https://community.qlik.com/t5/QlikView/How-to-count-nulls/m-p/212982#M66807 <HTML><HEAD></HEAD><BODY><P>Thanks Guy with all your answers!</P></BODY></HTML> Fri, 03 Dec 2010 23:20:20 GMT https://community.qlik.com/t5/QlikView/How-to-count-nulls/m-p/212982#M66807 ivandrago 2010-12-03T23:20:20Z