topic Issues with Guage Chart in QlikView https://community.qlik.com/t5/QlikView/Issues-with-Guage-Chart/m-p/226283#M78490 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>We have created a guage chart representation for What-iff tab to depict the What-if Revenue movement. I am trying to give a condition in the Text color option of the expression to show in green if What-if Rev increases the present revenue else in red. Its not working.....</P><P>can you please suggest if the condition I have given is correct.</P><P>= if( num (((if (Year='2011', sum(FAmount)) &amp; if(Year='2010',sum( AAmount))) * (1 + VRev/100)))&gt; num (if (Year='2011', sum(FAmount)) &amp; if(Year='2010',sum( AAmount))), Green(255), Red(255))</P><P>I am attaching the screenshot of What-if sheet.</P><P>Thanks and Regards,</P><P>Raghav</P></BODY></HTML> Mon, 19 Jul 2010 08:29:10 GMT raghavsurya 2010-07-19T08:29:10Z Issues with Guage Chart https://community.qlik.com/t5/QlikView/Issues-with-Guage-Chart/m-p/226283#M78490 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>We have created a guage chart representation for What-iff tab to depict the What-if Revenue movement. I am trying to give a condition in the Text color option of the expression to show in green if What-if Rev increases the present revenue else in red. Its not working.....</P><P>can you please suggest if the condition I have given is correct.</P><P>= if( num (((if (Year='2011', sum(FAmount)) &amp; if(Year='2010',sum( AAmount))) * (1 + VRev/100)))&gt; num (if (Year='2011', sum(FAmount)) &amp; if(Year='2010',sum( AAmount))), Green(255), Red(255))</P><P>I am attaching the screenshot of What-if sheet.</P><P>Thanks and Regards,</P><P>Raghav</P></BODY></HTML> Mon, 19 Jul 2010 08:29:10 GMT https://community.qlik.com/t5/QlikView/Issues-with-Guage-Chart/m-p/226283#M78490 raghavsurya 2010-07-19T08:29:10Z