Nested IF/AND/OR in Qlikview

[adurgani]

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]

[vishsaggi · Accepted solution]

May be Try this?

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