topic How to handle Null() values in QlikView

How to handle Null() values

Fri, 31 Jul 2009 12:43:41 GMT

Hi All,

I have a problem in handling the null values in the table box. If I subtract null from a value (Say 10- Null()), the result should be blank. Instead alikview changes the value of null to zero and it is giving the result as 10, which is wrong. I have this problem, only when I use addition or substraction. Please see the attachment.

--Santhosh

How to handle Null() values

Fri, 31 Jul 2009 19:24:40 GMT

You could try replacing 'Sum' with 'Only' in the expression.

=((

Sum(if(Code='OR', Amt))-Sum(if(Code='OP', Amt)))/(Sum(if(Code='OR',Amt))))

becomes;

=((only(if(Code='OR', Amt))-only(if(Code='OP', Amt)))/(only(if(Code='OR',Amt))))

How to handle Null() values

Fri, 31 Jul 2009 19:53:21 GMT

Do you have a NullAsValue in your script ?

or check your NullInterpreter variable ?

How to handle Null() values

Fri, 31 Jul 2009 20:17:39 GMT

Hi Tat,

Before, I saw your reply, I tried using the function 'mode' instead of sum and it solved the problem too. Do you think, is that the correct way.

How to handle Null() values

Fri, 31 Jul 2009 20:19:54 GMT

Hi Spastor,

I don't have nullasvalue in my script. I also don't have nullinterpreter and I don't know what is nullintrepreter.

How to handle Null() values

Fri, 31 Jul 2009 20:45:37 GMT

Ok,

NullInterpreter is a default variable which define how Qlikview will display null values.

Rgds,