Nprint Report Task Filter for Nulls

[tom2qlik]

Hi All,

I want an Nprint task to return results which are null in a specified field.

To do this I thought to list all the values of the field in the filter and tick the "Select Excluded" checkbox.

The result however returned the entire dataset.

Does anyone know how I can return values where my field is null?

Thanks,

Tom

[Lech_Miszkiewicz · Accepted solution]

you cannot select something what does not exist hence you cannot apply "null" selection!

populate null values with selectable characters and then apply selection on characters.

cheers

Lech