Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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>)
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())
Did you just try Null()?
IF(($(vForecastRound)=0 and $(vActualRound)=0), Null() ,<value if false>)
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())