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: 
michak80
Contributor III
Contributor III

Count if field is empty (null)

Hello,

I have a following table: 

LOCATION ID LOCATION TYPE
LOCATION 1 TEMP
LOCATION 2 TEMP
LOCATION 3 OUT
LOCATION 4 OUT
LOCATION 5 IN
LOCATION 6 null (empty)
LOCATION 7 null (empty)
LOCATION 8 COP
LOCATION 9 COP
LOCATION 10 XDC
LOCATION 11 XDC
LOCATION 12 XDC

 

I have a problem with null. I'm using 

Count({<LOCATION_TYPE ={'XDC','TEMP','NULL'}>} distinct LOCATION_ID) and I recieved only TEMP and XDC. What should I do to get also location where LOCATION TYPE is empty? 

1 Reply
anat
Master
Master

=Count(DISTINCT {<[Change Order Number]={"=Len(Trim(Check))=0 or Check = 1"}>}[Change Order Number])

Or 

=Count({<Check={"=Len(Trim(Check))=0"} > + <Check={"1"}>}[Change Order Number])

Can you try similar to the above