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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

count null values in document.

I want to create a table that counts the number of null values in each field.

i can do it for individual fields  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.

Thanks in advance

Rick

QV 8.5

0 Replies