How to handle Null() values

[#1]

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

[#2]

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))))

[#3]

Do you have a NullAsValue in your script ?

or check your NullInterpreter variable ?

[#4]

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.

[#5]

Hi Spastor,

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

[#6]

Ok,

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

Rgds,