Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to implement "FieldNullCount"?

Hi experts,

I'm try to make a table, whose rows are the field names of my data, and columns are statistics of fields.

I build a List Box with $Field as the field, and FieldValueCount($Field) as expression, which well displayed the distinct count of each field.

Now I want to display number of nulls in each field, but there is no "FieldNullCount" function.

Is there any way to implement one by expression?

Thank you!

2 Replies
RonaldDoes
Partner - Creator III
Partner - Creator III

Have you taken a look at the sheet object "statistics box"?

marcus_sommer

Take a look on the QVFieldObserver.qvw from rbecher: Re: Re: Chart with count of $Field values‌.

- Marcus