topic Visual Cues Question in QlikView https://community.qlik.com/t5/QlikView/Visual-Cues-Question/m-p/526715#M553871 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a table chart and one column has number values sorted ascending.</P><P>I need to give red color to the 20% of the lowest values and green to the rest. I thought it would be easy but I have stuck somehow... </P><P>Any thoughts?</P><P>Thanks!</P></BODY></HTML> Mon, 16 Sep 2013 14:33:06 GMT spyrosd80 2013-09-16T14:33:06Z Visual Cues Question https://community.qlik.com/t5/QlikView/Visual-Cues-Question/m-p/526715#M553871 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a table chart and one column has number values sorted ascending.</P><P>I need to give red color to the 20% of the lowest values and green to the rest. I thought it would be easy but I have stuck somehow... </P><P>Any thoughts?</P><P>Thanks!</P></BODY></HTML> Mon, 16 Sep 2013 14:33:06 GMT https://community.qlik.com/t5/QlikView/Visual-Cues-Question/m-p/526715#M553871 spyrosd80 2013-09-16T14:33:06Z Re: Visual Cues Question https://community.qlik.com/t5/QlikView/Visual-Cues-Question/m-p/526716#M553872 <HTML><HEAD></HEAD><BODY><P>You can use the rank function. See attached example. Click on the + in front of the expression (or dimension) and then click on Background Color to see the expression used for the color.</P></BODY></HTML> Mon, 16 Sep 2013 16:18:11 GMT https://community.qlik.com/t5/QlikView/Visual-Cues-Question/m-p/526716#M553872 Gysbert_Wassenaar 2013-09-16T16:18:11Z Re: Visual Cues Question https://community.qlik.com/t5/QlikView/Visual-Cues-Question/m-p/526717#M553873 <HTML><HEAD></HEAD><BODY><P>It worked!</P><P>Thanks a lot!!!</P></BODY></HTML> Mon, 16 Sep 2013 16:41:56 GMT https://community.qlik.com/t5/QlikView/Visual-Cues-Question/m-p/526717#M553873 spyrosd80 2013-09-16T16:41:56Z