topic Re: If Len Fuction in QlikView

If Len Fuction

Wed, 10 Dec 2014 08:38:31 GMT

Hi All

I would like to write an "If" statement that checks the number of characters in a field then return "N/A" if the field contains more than 15 characters, otherwise return the value

I tried this but it doesn't work:

If(Len(GUID>15,'N/A',GUID)) as GUID

Re: If Len Fuction

Wed, 10 Dec 2014 08:43:23 GMT

Hi Tumelo,

you have brackets in the wrong place, you need to close the Len

If(Len(GUID)>15,'N/A',GUID) as GUID

hope that helps

Joe

Re: If Len Fuction

yduval75 — Wed, 10 Dec 2014 08:43:28 GMT

Hello,

If(Len(GUID)>15,'N/A',GUID) as GUID

Re: If Len Fuction

anbu1984 — Wed, 10 Dec 2014 08:43:43 GMT

If(Len(GUID)>15,'N/A',GUID) as GUID

Re: If Len Fuction

Wed, 10 Dec 2014 08:46:04 GMT

hi Tumelo,

i think expression looks wrong, try the below:

If(Len(GUID)>15,'N/A',GUID) as GUID

Re: If Len Fuction

Wed, 10 Dec 2014 08:52:22 GMT

Thanks guys!

Re: If Len Fuction

Wed, 10 Dec 2014 08:57:39 GMT

And how do I include another If condition to say If the field GUID is NULL it must also return "N/A" ?

Re: If Len Fuction

anbu1984 — Wed, 10 Dec 2014 11:30:13 GMT

If(Len(GUID)>15 0r Len(Trim(GUID)) = 0,'N/A',GUID) as GUID

Note: I was unable to post with "0r" in above condition. Replace number zero by o in above expressions

Re: If Len Fuction

tombombadil — Wed, 10 Dec 2014 11:38:30 GMT

Just keep in mind, it's also possible to nest if statements:

If (Len(GUID), 'N/A', if(Len(GUID)>15, 'N/A', GUID)) as GUID

But of course, for this specific problem, anbu's solution looks better

Re: If Len Fuction

Wed, 10 Dec 2014 12:27:36 GMT

Thanks guys! again