topic Re: If Statement Null in QlikView

If Statement Null

cbaqir — Thu, 10 Dec 2015 19:59:10 GMT

I have a requirement to display Null in an if statement... if it's possible, what is the correct syntax?

IF(($(vForecastRound)=0 and $(vActualRound)=0),IsNull(Null()),<value if false>)

sunny_talwar — Thu, 10 Dec 2015 20:02:14 GMT

Did you just try Null()?

IF(($(vForecastRound)=0 and $(vActualRound)=0), Null() ,<value if false>)

maxgro — Thu, 10 Dec 2015 20:07:21 GMT

If I understand you don't want to check if null but only set an if condition to null()

IF(($(vForecastRound)=0 and $(vActualRound)=0) , Null(), <value if false>)

this is true in Qlik

=IsNull(null())