Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted

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". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

1 Reply
Highlighted

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". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post