topic Re: Text in chart expression help in QlikView https://community.qlik.com/t5/QlikView/Text-in-chart-expression-help/m-p/378063#M1168732 <HTML><HEAD></HEAD><BODY><P>Use calculated Base color in your Color area dialog:</P><P></P><P><EM>=if(</EM></P><P><EM> num($(vGrossSalesYTD)-$(vCancellationsYTD))-num($(vGrossSalesPTD) - $(vCancellationsPTD)) &lt; 0,</EM></P><P><EM>,lightred()</EM></P><P><EM>)</EM></P></BODY></HTML> Wed, 15 Aug 2012 12:09:55 GMT swuehl 2012-08-15T12:09:55Z Text in chart expression help https://community.qlik.com/t5/QlikView/Text-in-chart-expression-help/m-p/378062#M1168731 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I have the following expression as 'Text in Chart'</P><P></P><P>=num($(vGrossSalesYTD)-$(vCancellationsYTD))-num($(vGrossSalesPTD) - $(vCancellationsPTD))</P><P></P><P>I want the background of the text to go red if the result is a negative. </P><P></P><P>Can anyone help me on how to do this using a calculated background please?</P></BODY></HTML> Wed, 15 Aug 2012 11:58:14 GMT https://community.qlik.com/t5/QlikView/Text-in-chart-expression-help/m-p/378062#M1168731 hopkinsc 2012-08-15T11:58:14Z Re: Text in chart expression help https://community.qlik.com/t5/QlikView/Text-in-chart-expression-help/m-p/378063#M1168732 <HTML><HEAD></HEAD><BODY><P>Use calculated Base color in your Color area dialog:</P><P></P><P><EM>=if(</EM></P><P><EM> num($(vGrossSalesYTD)-$(vCancellationsYTD))-num($(vGrossSalesPTD) - $(vCancellationsPTD)) &lt; 0,</EM></P><P><EM>,lightred()</EM></P><P><EM>)</EM></P></BODY></HTML> Wed, 15 Aug 2012 12:09:55 GMT https://community.qlik.com/t5/QlikView/Text-in-chart-expression-help/m-p/378063#M1168732 swuehl 2012-08-15T12:09:55Z