topic Re: Highlight average price in QlikView https://community.qlik.com/t5/QlikView/Highlight-average-price/m-p/532713#M554310 <HTML><HEAD></HEAD><BODY><P>See attached example. Click on the + in front of the expression on the Expressions tab and then select Background Color to see the expression for the background color.</P></BODY></HTML> Tue, 17 Sep 2013 16:20:06 GMT Gysbert_Wassenaar 2013-09-17T16:20:06Z Highlight average price https://community.qlik.com/t5/QlikView/Highlight-average-price/m-p/532712#M554309 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to be able to highlight the highest and the smallest price or have some kind of color pattern from light red to dark red.</P><P>so for week 1 of Jan 2011 $5.50 I need it to be red and 2010 $8.65 to be green or from light red to dark red.</P><P></P><P></P><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/46631_pastedImage_1.png" style="width: 620px; height: 79px;" /></P><P></P><P>I have try using the Visual Cues and expressions but I'm not able to make this work.</P><P>please let me know if have an idea of what to do.</P><P></P><P>thank you so much!!!</P></BODY></HTML> Tue, 17 Sep 2013 16:08:32 GMT https://community.qlik.com/t5/QlikView/Highlight-average-price/m-p/532712#M554309 easternfish 2013-09-17T16:08:32Z Re: Highlight average price https://community.qlik.com/t5/QlikView/Highlight-average-price/m-p/532713#M554310 <HTML><HEAD></HEAD><BODY><P>See attached example. Click on the + in front of the expression on the Expressions tab and then select Background Color to see the expression for the background color.</P></BODY></HTML> Tue, 17 Sep 2013 16:20:06 GMT https://community.qlik.com/t5/QlikView/Highlight-average-price/m-p/532713#M554310 Gysbert_Wassenaar 2013-09-17T16:20:06Z Re: Highlight average price https://community.qlik.com/t5/QlikView/Highlight-average-price/m-p/532714#M554311 <HTML><HEAD></HEAD><BODY><P>Genius!</P><P>Thank you </P></BODY></HTML> Tue, 17 Sep 2013 16:44:57 GMT https://community.qlik.com/t5/QlikView/Highlight-average-price/m-p/532714#M554311 easternfish 2013-09-17T16:44:57Z