topic How to implement &quot;FieldNullCount&quot;? in QlikView https://community.qlik.com/t5/QlikView/How-to-implement-quot-FieldNullCount-quot/m-p/1311555#M829788 <HTML><HEAD></HEAD><BODY><P>Hi experts,</P><P></P><P>I'm try to make a table, whose rows are the field names of my data, and columns are statistics of fields.</P><P></P><P>I build a List Box with $Field as the field, and FieldValueCount($Field) as expression, which well displayed the distinct count of each field.</P><P></P><P>Now I want to display number of nulls in each field, but there is no "FieldNullCount" function.</P><P>Is there any way to implement one by expression?</P><P></P><P>Thank you!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z How to implement "FieldNullCount"? https://community.qlik.com/t5/QlikView/How-to-implement-quot-FieldNullCount-quot/m-p/1311555#M829788 <HTML><HEAD></HEAD><BODY><P>Hi experts,</P><P></P><P>I'm try to make a table, whose rows are the field names of my data, and columns are statistics of fields.</P><P></P><P>I build a List Box with $Field as the field, and FieldValueCount($Field) as expression, which well displayed the distinct count of each field.</P><P></P><P>Now I want to display number of nulls in each field, but there is no "FieldNullCount" function.</P><P>Is there any way to implement one by expression?</P><P></P><P>Thank you!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-implement-quot-FieldNullCount-quot/m-p/1311555#M829788 2020-11-25T16:16:04Z Re: How to implement "FieldNullCount"? https://community.qlik.com/t5/QlikView/How-to-implement-quot-FieldNullCount-quot/m-p/1311556#M829789 <HTML><HEAD></HEAD><BODY><P>Have you taken a look at the sheet object "statistics box"?</P></BODY></HTML> Mon, 19 Jun 2017 12:18:49 GMT https://community.qlik.com/t5/QlikView/How-to-implement-quot-FieldNullCount-quot/m-p/1311556#M829789 RonaldDoes 2017-06-19T12:18:49Z Re: How to implement "FieldNullCount"? https://community.qlik.com/t5/QlikView/How-to-implement-quot-FieldNullCount-quot/m-p/1311557#M829790 <HTML><HEAD></HEAD><BODY><P>Take a look on the <SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">QVFieldObserver.qvw</SPAN> from <A href="https://community.qlik.com/qlik-users/3136">rbecher</A>: <A href="https://community.qlik.com/message/386631">Re: Re: Chart with count of $Field values</A>‌.</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 19 Jun 2017 13:17:13 GMT https://community.qlik.com/t5/QlikView/How-to-implement-quot-FieldNullCount-quot/m-p/1311557#M829790 marcus_sommer 2017-06-19T13:17:13Z