topic count null values in document. in QlikView https://community.qlik.com/t5/QlikView/count-null-values-in-document/m-p/417187#M155119 <HTML><HEAD></HEAD><BODY><P>I want to create a table that counts the number of null values in each field.</P><P>i can do it for individual fields&nbsp; e.g. count(if(isnull(Field1),1)) but i wanted to use $Field and $Table to make a pivot table the does it for all fields in the whole document.</P><P>Thanks in advance</P><P></P><P>Rick</P><P></P><P></P><P>QV 8.5</P></BODY></HTML> Fri, 07 Dec 2012 13:06:30 GMT 2012-12-07T13:06:30Z count null values in document. https://community.qlik.com/t5/QlikView/count-null-values-in-document/m-p/417187#M155119 <HTML><HEAD></HEAD><BODY><P>I want to create a table that counts the number of null values in each field.</P><P>i can do it for individual fields&nbsp; e.g. count(if(isnull(Field1),1)) but i wanted to use $Field and $Table to make a pivot table the does it for all fields in the whole document.</P><P>Thanks in advance</P><P></P><P>Rick</P><P></P><P></P><P>QV 8.5</P></BODY></HTML> Fri, 07 Dec 2012 13:06:30 GMT https://community.qlik.com/t5/QlikView/count-null-values-in-document/m-p/417187#M155119 2012-12-07T13:06:30Z