Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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.

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