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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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