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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Nprinting with NULL value

Hello everyone,

I am using Nprinting 16.

Can we made filter with NULL/BLANK value. I want to get the NULL/BLANK value only

I have tried to use "Excluded" to get NULL/BLANK but it did not have right value.

Eg. Gender = {"Male","Female",""}

I tried to set exclude {"Male","Female"} but it still show all. In this case, I just want to get Gendern = ""

Thanks for any sugguestion.

Labels (1)
2 Replies
cbaqir
Specialist II
Specialist II

try isnull(Gender)?

trdandamudi
Master II
Master II

May be as below:

Len(Trim(Gender))=0

OR

Set Analysis

{<Gender -= {'Male','Female'}>}   < ---- Please notice minus ( - ) symbol in front of equal sign