Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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