topic ISNULL function in QlikView

ISNULL function

Tue, 28 Apr 2009 23:04:21 GMT

Hello Fellow users,

I have a problem with the following statement, cann someone help me, here it comes.

I have three fields FOB_BILLING , FREIGHT_EST, RESULT. I would like to write the following formula:

If (FOB_BILLING <=0 then Field RESULT should be 0.

iF(FOB_BILLING >0 then Field RESULT Should have the value of FREIGHT_EST .

I tried the following statement:

IF(ISNULL(FOB_BILLING)= '0', FREIGHT_EST,'0') as RESULT,

Greetings from Holland,

Aissam

yblake — Tue, 28 Apr 2009 23:08:51 GMT

let's try :

IF(IF(ISNULL(FOB_BILLING),0,FOB_BILLING) > 0, FREIGHT_EST,0) as RESULT,

Tue, 28 Apr 2009 23:28:09 GMT

Thanks Yves,

It works,

Merci beaucoup,

Aissam

Tue, 28 Apr 2009 23:28:53 GMT

I don't understand why you should need the ISNULL() function for this problem, I would fix it like this:

IF(FOB_BILLING>0,FREIGHT_EST,'0') AS RESULT

Otherwise like this:

IF(ISNULL(FOB_BILLING),'0',IF(FOB_BILLING<=0,'0',FREIGHT_EST)) AS RESULT

Wed, 29 Apr 2009 14:05:00 GMT

This works also.

Bedankt,

Aissam