topic length function in QlikView

length function

Tue, 27 May 2014 09:58:30 GMT

Hi,

Does anyone know how to use a length function i.e. only bring back data from a certain field if the characters for example are greater than 5?

Any help will be welcomed?

Thanks Naz

tresB — Tue, 27 May 2014 09:59:56 GMT

where len(field)>5 ;

anbu1984 — Tue, 27 May 2014 10:00:48 GMT

Where Len(Trim(YourField)) > 5

maxgro — Tue, 27 May 2014 10:04:41 GMT

exclude row --> tresesco

change field value (or set null) --> below

load

....

if(len(field)>5, field) as field,

if(len(field)>5, field, '>5') as field1,

....

from

...;