I create a pivot table with all the needed fields and do see that some row contains NULL entry on a particular field or column. Now I just want the system to filter for just the NULL entries. The goal is to have a report showing all record with NULL entry in field X.
i don't think you can do selections on nulls in Qlikview. The way i've solved this is on the load script, i make sure to put some text value on these null ones (i.e. MISSING, EMPTY, '<empty string>', etc. ). This way i can filter by them.
Will replace all null values with 'null' for the Field. There is other functions (something like nullinterpret etc) that might do the trick but this is the one i use. You can also use this function in your pivot table expressions.