Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
mazman65
Contributor III
Contributor III

Empty Cell not being picked up as NULL

I have a column of data that contains NULLS and "white space" and I need the "white space" to be identified in some way so I can sort them out and to be able to count the NULLS and "white space".

In my LOAD script I am using:

SET NullValue = '<Unknown>';
NullAsValue
*;

Below are the results in the INCIDENT TTF DEADLINE TIMESTAMP field which is a Date field

Picture1.jpg

Suggestions on how to get the "white space" identified?

Thanks!

Dan

1 Reply
hector_munoz
Specialist
Specialist

Hi Dan,

A trick could be If(Len(<field>) > 0 AND Trim(<field>) = 0, <White Space>, [INCIDENT TTF DEADLINE TIMESTAMP]) AS [INCIDENT TTF DEADLINE TIMESTAMP]

Regards;
H