topic Re: Checking for NULL in script in QlikView

Checking for NULL in script

naveenchellaara — Sat, 23 Feb 2013 11:52:16 GMT

How to check for null values in the script file?

I have a variable.

var1

I need to check whether the value of the variable is null or not.

i tried

IF( $(var1) = Null

then

set Var2 = Blue();

endif

but it is thowing an error.

Regards

Naveenchellaaraam

nagaiank — Sat, 23 Feb 2013 12:30:25 GMT

IsNull(X) returns True if X is null.

Also Len(Trim(X)) = 0 if X is null.

SunilChauhan — Sat, 23 Feb 2013 14:59:55 GMT

try below code .

if(isnull($(var1)),Blue())

if(len($(var1))=0,Blue())

if(($(var1))=' ',Blue())

hope this helps

phaneendra_kunc — Sat, 23 Feb 2013 15:09:40 GMT

Try this....

If Len ($(var1)) = 0 then

Set Var2 = 'blue()';

Endif.

rwunderlich — Sat, 23 Feb 2013 17:55:49 GMT

I think the most robust test is

len('$(v1)') = 0

Note the single quotes around the variable.

-Rob