https://community.qlik.com/t5/QlikView/Visual-Cues-Expression-for-rank/m-p/209454#M64430 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Does anyone know what expressions i need to add so that i can add visual cues for 3 different columns based on % rank?</P><P>E.g i want columns <B>session count</B>, <B>total duration (hrs)</B>, <B>avg duration (hrs)</B> to be visually represented by the following:</P><UL><LI>Green - top 25% of value</LI><LI>Amber - 25-75% of value</LI><LI>Red 75% of value</LI></UL><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-2403_sourceID:2403" /></P><P>Any Ideas?</P></BODY></HTML> Mon, 20 Sep 2010 15:01:58 GMT 2010-09-20T15:01:58Z https://community.qlik.com/t5/QlikView/Visual-Cues-Expression-for-rank/m-p/209454#M64430 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Does anyone know what expressions i need to add so that i can add visual cues for 3 different columns based on % rank?</P><P>E.g i want columns <B>session count</B>, <B>total duration (hrs)</B>, <B>avg duration (hrs)</B> to be visually represented by the following:</P><UL><LI>Green - top 25% of value</LI><LI>Amber - 25-75% of value</LI><LI>Red 75% of value</LI></UL><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-2403_sourceID:2403" /></P><P>Any Ideas?</P></BODY></HTML> Mon, 20 Sep 2010 15:01:58 GMT https://community.qlik.com/t5/QlikView/Visual-Cues-Expression-for-rank/m-p/209454#M64430 2010-09-20T15:01:58Z