topic Visual Cue greater than total in QlikView https://community.qlik.com/t5/QlikView/Visual-Cue-greater-than-total/m-p/373450#M138959 <HTML><HEAD></HEAD><BODY><P>How can i add a visual cue, that includes the condition if greater than the total, highlight green?</P><P></P><P>the expression is variance calculation, right now its sell thru TY - sell thru LY. </P></BODY></HTML> Tue, 29 May 2012 20:41:14 GMT 2012-05-29T20:41:14Z Visual Cue greater than total https://community.qlik.com/t5/QlikView/Visual-Cue-greater-than-total/m-p/373450#M138959 <HTML><HEAD></HEAD><BODY><P>How can i add a visual cue, that includes the condition if greater than the total, highlight green?</P><P></P><P>the expression is variance calculation, right now its sell thru TY - sell thru LY. </P></BODY></HTML> Tue, 29 May 2012 20:41:14 GMT https://community.qlik.com/t5/QlikView/Visual-Cue-greater-than-total/m-p/373450#M138959 2012-05-29T20:41:14Z Re: Visual Cue greater than total https://community.qlik.com/t5/QlikView/Visual-Cue-greater-than-total/m-p/373451#M138960 <HTML><HEAD></HEAD><BODY><P>Try a background color attribute expression from expression tab (open attributes by clicking on the plus sign next to your expression) instead of a visual cue to enter a color expression like</P><P></P><P><EM>=if( (sum(SalesTY)-sum(SalesLY) ) &gt; (sum(total SalesTY)-sum(total SalesLY) ), green() ) </EM></P><P></P><P>I am not 100% sure about the sum expression, in principal you need to use something like </P><P>if( yourLineExpression &gt; yourTotalExpresssion, green() )</P><P></P><P>where yourLineExpression is calculating your table line values per dimension (essentially your current expression), and yourTotalExpression calculates the total value.</P><P></P><P>See attached for a simple example.</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Tue, 29 May 2012 21:24:50 GMT https://community.qlik.com/t5/QlikView/Visual-Cue-greater-than-total/m-p/373451#M138960 swuehl 2012-05-29T21:24:50Z