topic Re: Subtract Null - Value in QlikView

Subtract Null - Value

Fri, 27 Jun 2014 06:36:12 GMT

I have a scenario , whre i have to subtract the null value with the value.

Pls find the attached file...

Thanks

Re: Subtract Null - Value

its_anandrjs — Fri, 27 Jun 2014 06:49:30 GMT

Now check i forget some thing before

Try this way in expression

=Sum( if( len(A) = 0,0,A) - B)

=Sum(B - if( len(A) = 0,0,A) )

Re: Subtract Null - Value

amit_saini — Fri, 27 Jun 2014 06:53:50 GMT

Senthil,

Please see the attachment.

Thanks,

Re: Subtract Null - Value

hic — Fri, 27 Jun 2014 07:12:34 GMT

For arithmetic operations on NULL values, you should always use the Range functions. Hence, to calculate the difference between two fields, you should use:

Sum( RangeSum( A, -B ) )

A conditional expression like e.g. If(IsNull( A ), .... ) will always take longer time to evaluate.

HIC

Re: Subtract Null - Value

SunilChauhan — Fri, 27 Jun 2014 07:22:50 GMT

Sum( if( isnull(A) ,0,A) - sum(B)

Re: Subtract Null - Value

Fri, 27 Jun 2014 07:32:37 GMT

Hi,

Hope you are looking for the below result.

Please check the attched file for the same.