topic Why does If statement show Null in QlikView

Why does If statement show Null

Thu, 30 Aug 2012 13:13:55 GMT

if(Year(Opportunity.CreatedDate) = $(vCurrentYear),

if(Year(Quote.CreatedDate) = $(vCurrentYear),

if(Quote.GrandTotal >= 0, 1, 0))) as Quotes

Why does this come back Null?

This is off a resident load.

m_woolf — Thu, 30 Aug 2012 13:23:02 GMT

I'll state the obvious:

Year(Opportunity.CreatedDate) <> $(vCurrentYear

or Year(Quote.CreatedDate) <> $(vCurrentYear)

jagannalla — Thu, 30 Aug 2012 13:25:18 GMT

Hello,

1. If Year(Opportunity.CreatedDate) = $(vCurrentYear) is false then it takes null.

2. If if(Year(Quote.CreatedDate) = $(vCurrentYear) is false then it takes null.

3. If both conditions are true then it enters the third condition. Here if the condition is true then it holds 1 otherwise 0.

But in first two conditions if it is false it stores Null values.

Cheers!!

Jagan