Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
cbaqir
Specialist II
Specialist 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>)

1 Solution

Accepted Solutions
maxgro
MVP
MVP

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

View solution in original post

2 Replies
sunny_talwar

Did you just try Null()?

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

maxgro
MVP
MVP

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