Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
adurgani
Contributor III
Contributor III

Nested IF/AND/OR in Qlikview

How would you script this in Qlikview.

=IF(AND(EB2<>1,OR(BL2<>0,BL2<>"")),"Error","OK")

Have spent hours already and this is as far as I got. Any help is really appreciated.

If ( [EB2] -= 1 and  [BL2]-=0 or [BL2]-=''  ,"Error","OK") as [Jan Test]

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

May be Try this?

If ( [EB2]  <> 1 and  ( [BL2] <> 0 OR NOT ISNULL([BL2]) = -1), 'Error', 'OK')  as [Jan Test]

View solution in original post

1 Reply
vishsaggi
Champion III
Champion III

May be Try this?

If ( [EB2]  <> 1 and  ( [BL2] <> 0 OR NOT ISNULL([BL2]) = -1), 'Error', 'OK')  as [Jan Test]