topic Re: Between in QlikView https://community.qlik.com/t5/QlikView/Between/m-p/4003#M790843 <HTML><HEAD></HEAD><BODY><P>For Logic operator you should written AND like</P><P></P><P><SPAN style="color: #008000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 18.6667px;">If(CurrentRatingOverall &gt;1.4 and <SPAN style="color: #008000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 18.6667px;">CurrentRatingOverall </SPAN> &lt;2.5,1) AS Yellow,</SPAN></P></BODY></HTML> Fri, 19 Jan 2018 18:25:37 GMT Anil_Babu_Samineni 2018-01-19T18:25:37Z Between https://community.qlik.com/t5/QlikView/Between/m-p/4002#M790842 <HTML><HEAD></HEAD><BODY><P>The red and green below are working but I forgot the syntax for how to do yellow:</P><P></P><P><SPAN style="font-size: 14pt;">&nbsp;&nbsp; </SPAN><SPAN style="font-size: 14pt;"><SPAN style="color: #0000ff;">If</SPAN>(<SPAN style="color: #800000;">CurrentRatingOverall</SPAN> &gt;= '2.5',1) <SPAN style="color: #0000ff;">AS</SPAN> <SPAN style="color: #800000;">Green</SPAN>,<BR /> <SPAN style="color: #008000;">// If(CurrentRatingOverall &gt;1.4 &lt;2.5,1) AS Yellow,<BR /> </SPAN>&nbsp;&nbsp; <SPAN style="color: #0000ff;">If</SPAN>(<SPAN style="color: #800000;">CurrentRatingOverall</SPAN> &lt; '1.5',1) <SPAN style="color: #0000ff;">AS</SPAN> <SPAN style="color: #800000;">Red</SPAN></SPAN><SPAN style="font-size: 14pt;">, </SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Between/m-p/4002#M790842 fanninam 2020-11-25T16:16:04Z Re: Between https://community.qlik.com/t5/QlikView/Between/m-p/4003#M790843 <HTML><HEAD></HEAD><BODY><P>For Logic operator you should written AND like</P><P></P><P><SPAN style="color: #008000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 18.6667px;">If(CurrentRatingOverall &gt;1.4 and <SPAN style="color: #008000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 18.6667px;">CurrentRatingOverall </SPAN> &lt;2.5,1) AS Yellow,</SPAN></P></BODY></HTML> Fri, 19 Jan 2018 18:25:37 GMT https://community.qlik.com/t5/QlikView/Between/m-p/4003#M790843 Anil_Babu_Samineni 2018-01-19T18:25:37Z