Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
arsenal1983
Creator
Creator

NULL vs SPACE

Hello, I would like to create column in loading script base on the source column. My new column should be a flag:

if (isnull(SOURCE), 1, 0)

The problem is that in source data sometimes I have null but sometimes it is space or even several spaces. I tried with TRIM function:

if(isnull(trim(SOURCE)), 1, 0)

but it did not work.

Could you help me please?

1 Solution

Accepted Solutions
robert_mika
Master III
Master III

try:

if(Len(TRIM((SOURCE))=0....

View solution in original post

1 Reply
robert_mika
Master III
Master III

try:

if(Len(TRIM((SOURCE))=0....

View solution in original post