Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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())