Discussion Board for collaboration related to QlikView App Development.
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
Suggestions on how to get the "white space" identified?
A trick could be If(Len(<field>) > 0 AND Trim(<field>) = 0, <White Space>, [INCIDENT TTF DEADLINE TIMESTAMP]) AS [INCIDENT TTF DEADLINE TIMESTAMP]