Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

tom2qlik
New Contributor III

Nprint Report Task Filter for Nulls

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

1 Solution

Accepted Solutions
Lech_Miszkiewicz
Honored Contributor III

Re: Nprint Report Task Filter for Nulls

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

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
1 Reply
Lech_Miszkiewicz
Honored Contributor III

Re: Nprint Report Task Filter for Nulls

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

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
Community Browser