Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
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!

Labels (1)
2 Replies
RonaldDoes
Partner - Creator III
Partner - Creator III

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

marcus_sommer
MVP
MVP

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

- Marcus