Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
adurgani
New 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
Highlighted
vishsaggi
Esteemed Contributor III

Re: Nested IF/AND/OR in Qlikview

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
Highlighted
vishsaggi
Esteemed Contributor III

Re: Nested IF/AND/OR in Qlikview

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