Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

cbaqirdhds
Contributor II

If Statement Null

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>)

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: If Statement Null

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())

2 Replies

Re: If Statement Null

Did you just try Null()?

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

MVP
MVP

Re: If Statement Null

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())

Community Browser