topic Nprinting with NULL value in QlikView

Nprinting with NULL value

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

cbaqir — Tue, 07 Nov 2017 21:05:03 GMT

try isnull(Gender)?

trdandamudi — Tue, 07 Nov 2017 21:54:20 GMT

May be as below:

Len(Trim(Gender))=0

Set Analysis

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