topic Check if field is null in script, in conditional statement in QlikView

Check if field is null in script, in conditional statement

Mon, 08 Jul 2013 08:35:27 GMT

Hello,

I want to check if a value is Null, and if it is Null, I want to assign a value. This is what im trying:

if(IsNull([Stock]), [Stock] = 1, [Stock]) as [Stock]

Problem is, when I check the value the [Stock] = 0. So instead of making it 1 its 0.

How can I do this different?

Sokkorn — Mon, 08 Jul 2013 08:39:09 GMT

Hi,

Did you try something like this yet:

If(IsNull([Stock]),0,[Stock]) AS [Stock],

Or If(Len([Stock])=0,0,[Stock]) AS [Stock],

Regards,

Sokkorn

Mon, 08 Jul 2013 08:41:19 GMT

All the non-null values turn into -1 for some reason when I use this.

Sokkorn — Mon, 08 Jul 2013 08:43:32 GMT

Hi,

Does your [Stock] field have null value or not? And if [Stock] is null then what value you want to assign?

Regards,

Sokkorn

Mon, 08 Jul 2013 08:49:32 GMT

if([Stock]=' ', 1, [Stock]) as [Stock]

Mon, 08 Jul 2013 08:58:11 GMT

Thanks alot! this worked for me. But instead of [Stock]=' ' I could use IsNull([Stock]). But just putting 1 in the second field worked.