topic Counting If between numbers in QlikView https://community.qlik.com/t5/QlikView/Counting-If-between-numbers/m-p/971879#M967353 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am using a straight table and trying to multiple two columns and add background colour based on the results.</P><P></P><P>The expression is Maths * English</P><P></P><P>In the "Background Colour" Section under expressions, I added,</P><P></P><P>=<SPAN style="color: #0000ff;">IF</SPAN>(<SPAN style="color: #800000;">Maths</SPAN> * <SPAN style="color: #800000;">English</SPAN>&gt;12, <SPAN style="color: #0000ff;">LightRed</SPAN>(), <BR /> <SPAN style="color: #0000ff;">if</SPAN>(<SPAN style="color: #800000;">Maths</SPAN> * <SPAN style="color: #800000;">English</SPAN>&lt;=12 <SPAN style="color: #0000ff;">and</SPAN> <SPAN style="color: #0000ff;">if</SPAN>(<SPAN style="color: #800000;">Maths</SPAN> * <SPAN style="color: #800000;">English</SPAN>&gt;=8, <SPAN style="color: #0000ff;">LightMagenta</SPAN>()), <SPAN style="color: #0000ff;">LightGray</SPAN>())).</P><P></P><P>The first If works (&gt;12 changes to LightRed()). However, LightGray() appears for the second category, i.e., values between 8 and 12. LightMagenta does not appear anywhere. Values below 8 has no background colour, appears in white. What am I doing wrong please?</P><P></P><P>Regards,</P><P>Karthik</P></BODY></HTML> Wed, 30 Sep 2015 15:21:49 GMT infock12 2015-09-30T15:21:49Z Counting If between numbers https://community.qlik.com/t5/QlikView/Counting-If-between-numbers/m-p/971879#M967353 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am using a straight table and trying to multiple two columns and add background colour based on the results.</P><P></P><P>The expression is Maths * English</P><P></P><P>In the "Background Colour" Section under expressions, I added,</P><P></P><P>=<SPAN style="color: #0000ff;">IF</SPAN>(<SPAN style="color: #800000;">Maths</SPAN> * <SPAN style="color: #800000;">English</SPAN>&gt;12, <SPAN style="color: #0000ff;">LightRed</SPAN>(), <BR /> <SPAN style="color: #0000ff;">if</SPAN>(<SPAN style="color: #800000;">Maths</SPAN> * <SPAN style="color: #800000;">English</SPAN>&lt;=12 <SPAN style="color: #0000ff;">and</SPAN> <SPAN style="color: #0000ff;">if</SPAN>(<SPAN style="color: #800000;">Maths</SPAN> * <SPAN style="color: #800000;">English</SPAN>&gt;=8, <SPAN style="color: #0000ff;">LightMagenta</SPAN>()), <SPAN style="color: #0000ff;">LightGray</SPAN>())).</P><P></P><P>The first If works (&gt;12 changes to LightRed()). However, LightGray() appears for the second category, i.e., values between 8 and 12. LightMagenta does not appear anywhere. Values below 8 has no background colour, appears in white. What am I doing wrong please?</P><P></P><P>Regards,</P><P>Karthik</P></BODY></HTML> Wed, 30 Sep 2015 15:21:49 GMT https://community.qlik.com/t5/QlikView/Counting-If-between-numbers/m-p/971879#M967353 infock12 2015-09-30T15:21:49Z Re: Counting If between numbers https://community.qlik.com/t5/QlikView/Counting-If-between-numbers/m-p/971880#M967354 <HTML><HEAD></HEAD><BODY><P>Hi Karthik, try with this:</P><P>=<SPAN style="color: #0000ff;">IF</SPAN>(<SPAN style="color: #800000;">Maths</SPAN> * <SPAN style="color: #800000;">English</SPAN>&gt;12, <SPAN style="color: #0000ff;">LightRed</SPAN>(), </P><P>&nbsp;&nbsp; <SPAN style="color: #0000ff;">if</SPAN>(<SPAN style="color: #800000;">Maths</SPAN> * <SPAN style="color: #800000;">English</SPAN>&gt;=8, <SPAN style="color: #0000ff;">LightMagenta</SPAN>(), <SPAN style="color: #0000ff;">LightGray</SPAN>())).</P></BODY></HTML> Wed, 30 Sep 2015 15:28:52 GMT https://community.qlik.com/t5/QlikView/Counting-If-between-numbers/m-p/971880#M967354 rubenmarin 2015-09-30T15:28:52Z Re: Counting If between numbers https://community.qlik.com/t5/QlikView/Counting-If-between-numbers/m-p/971881#M967355 <HTML><HEAD></HEAD><BODY><P>Hi Ruben,</P><P></P><P>Yes, it works. Thank you very much!</P></BODY></HTML> Wed, 30 Sep 2015 15:32:47 GMT https://community.qlik.com/t5/QlikView/Counting-If-between-numbers/m-p/971881#M967355 infock12 2015-09-30T15:32:47Z