topic check this statement it is not working (Aoiding null values) in QlikView

check this statement it is not working (Aoiding null values)

Wed, 16 Mar 2011 07:00:41 GMT

sum

(if(trim(IS_MIN=1 and IS_MIN<>11 and IS_MIN <>0), (if(cm=null() , [CM],0))+ (if(OTHER_CM=null() , [OTHER_CM],0)), null())))

check this statement it is not working (Aoiding null values)

Wed, 16 Mar 2011 07:35:32 GMT

Hi,

sum(if(trim(IS_MIN=1) and trim(IS_MIN<>11) and trim(IS_MIN <>0),

((if(cm=null() , [CM],0))+ (if(OTHER_CM=null() , [OTHER_CM],0)))))

try this.

i hope it help's

Regards,

chandra

check this statement it is not working (Aoiding null values)

Wed, 16 Mar 2011 08:10:41 GMT

It is giving o result, it is not working.

Thankyou for quick response

Regards

Akmal Imtiaz

check this statement it is not working (Aoiding null values)

tresB — Wed, 16 Mar 2011 08:17:57 GMT

Hi Akmal,

Can you explain in words what you want (your logic) ? and one more thing, if you verify a post, it means it is working for, you.

Regards, tresesco

check this statement it is not working (Aoiding null values)

Wed, 16 Mar 2011 08:24:26 GMT

CM and OTHER_CM may have null values ,du to this reason this statament is not giving result.

Regards

Akmal Imtiaz

check this statement it is not working (Aoiding null values)

Wed, 16 Mar 2011 09:36:08 GMT

Both of these statement are not working.

Statement no. 1

sum(

(trim(IS_MIN=1 and IS_MIN<>11 and IS_MIN <>0), (if(cm=null() , [CM],0))+ (if(OTHER_CM=null() , [OTHER_CM],0)), null

()))

Statement no. 2

sum(if(trim(IS_MIN=1) and trim(IS_MIN<>11) and trim(IS_MIN <>0), ((if(cm=null() , [CM],0))+ (if(OTHER_CM=null() , [OTHER_CM]

,0)))))

check this statement it is not working (Aoiding null values)

Wed, 16 Mar 2011 09:46:00 GMT

Hi,

please find attachment. i tried with one example, still u r not get solution post app with sample data.

Thanks,

Chandra

check this statement it is not working (Aoiding null values)

Wed, 16 Mar 2011 09:46:27 GMT

It is not working.

check this statement it is not working (Aoiding null values)

Wed, 16 Mar 2011 10:22:34 GMT

Thank you very much, it is working.