topic Re: IF statement in the script in QlikView

IF statement in the script

Wed, 11 Mar 2015 12:50:28 GMT

Hi guys,

How to properly wright the script which will create new column and add data as followed: check 2 columns ([name A] and [name B] - ALWAYS only one of them might have data and NEVER both, sometimes both columns might be empty) and add it to created new column

I am sure it is simple IF statement, but I am not sure how to check if field is empy.

Thank you,

Andrzej

Re: IF statement in the script

sunny_talwar — Wed, 11 Mar 2015 12:54:37 GMT

you can do something like this:

LOAD yourOtherFields,

Alt([Name A], [Name B]) as NewColumn

Resident/From XYZ;

This would work in your situation where only one or the other will have a value.

HTH

Best,

Re: IF statement in the script

sunny_talwar — Wed, 11 Mar 2015 12:57:23 GMT

Or the alternative if the above doesn't work would be:

If(IsNull([Name A]), [Name B], [Name A]) as NewColumn

Best,

Re: IF statement in the script

Wed, 11 Mar 2015 12:59:17 GMT

The first solution didn't work for me...

Re: IF statement in the script

Wed, 11 Mar 2015 13:04:03 GMT

I changed the second solution a little but basicaly "IsNull" this is what i was looking for.

if(not isNull(NameA), NameA, if(not isnull(NameB), NameB)) as [New Name],

Re: IF statement in the script

sunny_talwar — Wed, 11 Mar 2015 13:04:30 GMT

I guess the second one worked then, since you marked it as a correct answer.

Best,