topic Re: Nested IF/AND/OR in Qlikview in QlikView https://community.qlik.com/t5/QlikView/Nested-IF-AND-OR-in-Qlikview/m-p/1411748#M799954 <HTML><HEAD></HEAD><BODY><P>May be Try this? </P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">If ( [EB2]&nbsp; &lt;&gt; 1 and&nbsp; ( [BL2] &lt;&gt; 0 OR NOT ISNULL([BL2]) = -1), 'Error', 'OK')&nbsp; as [Jan Test]</SPAN></P></BODY></HTML> Fri, 01 Dec 2017 19:23:40 GMT vishsaggi 2017-12-01T19:23:40Z Nested IF/AND/OR in Qlikview https://community.qlik.com/t5/QlikView/Nested-IF-AND-OR-in-Qlikview/m-p/1411747#M799953 <HTML><HEAD></HEAD><BODY><P>How would you script this in Qlikview. </P><P></P><P>=IF(AND(EB2&lt;&gt;1,OR(BL2&lt;&gt;0,BL2&lt;&gt;"")),"Error","OK")</P><P></P><P>Have spent hours already and this is as far as I got. Any help is really appreciated.</P><P></P><P></P><P>If ( [EB2] -= 1 and&nbsp; [BL2]-=0 or [BL2]-=''&nbsp; ,"Error","OK") as [Jan Test]</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Nested-IF-AND-OR-in-Qlikview/m-p/1411747#M799953 adurgani 2020-11-25T16:16:04Z Re: Nested IF/AND/OR in Qlikview https://community.qlik.com/t5/QlikView/Nested-IF-AND-OR-in-Qlikview/m-p/1411748#M799954 <HTML><HEAD></HEAD><BODY><P>May be Try this? </P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">If ( [EB2]&nbsp; &lt;&gt; 1 and&nbsp; ( [BL2] &lt;&gt; 0 OR NOT ISNULL([BL2]) = -1), 'Error', 'OK')&nbsp; as [Jan Test]</SPAN></P></BODY></HTML> Fri, 01 Dec 2017 19:23:40 GMT https://community.qlik.com/t5/QlikView/Nested-IF-AND-OR-in-Qlikview/m-p/1411748#M799954 vishsaggi 2017-12-01T19:23:40Z