topic Find blanks in text field in QlikView

Find blanks in text field

Fri, 10 Oct 2014 07:31:05 GMT

I tried to use the expression

count(IF(text=' ',items)) to find all items where the text field is blank - but?????????????????????????

manuelreimitz — Fri, 10 Oct 2014 07:34:23 GMT

=count(if(len(trim(text)) = 0, item))

do the "trim" operation in load script and flag the dataset!

LOAD

id,

text,

f(len(trim(text)) = 0, 0, 1) as EmptyFlag,

item

RESIDENT Table:

Fri, 10 Oct 2014 07:36:54 GMT

Hurra - it works