Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]
May be Try this?
If ( [EB2] <> 1 and ( [BL2] <> 0 OR NOT ISNULL([BL2]) = -1), 'Error', 'OK') as [Jan Test]
May be Try this?
If ( [EB2] <> 1 and ( [BL2] <> 0 OR NOT ISNULL([BL2]) = -1), 'Error', 'OK') as [Jan Test]