https://community.qlik.com/t5/App-Development/Colour-Expression/m-p/1808448#M65839 <P>I have a scenario where I need to analyze survey data to highlight areas of improvement. Some sample data:</P><TABLE border="1"><TBODY><TR><TD>Service</TD><TD>Price</TD><TD>Experience</TD></TR><TR><TD>5</TD><TD>2</TD><TD>3</TD></TR><TR><TD>4</TD><TD>2</TD><TD>2</TD></TR><TR><TD>4</TD><TD>1</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I am trying to use Combo / Bar charts to display the average results and highlight the areas which needs improvement. If the Average score is above 3, the bar will be green. If not, it will be red.&nbsp;</P><P>Been exploring with IF and AVG functions but I am having troubles as I have more than just 3 criteria as it will be an extremely long expression. Any advice?</P> Mon, 17 May 2021 15:14:51 GMT jeremyyeo93 2021-05-17T15:14:51Z https://community.qlik.com/t5/App-Development/Colour-Expression/m-p/1808448#M65839 <P>I have a scenario where I need to analyze survey data to highlight areas of improvement. Some sample data:</P><TABLE border="1"><TBODY><TR><TD>Service</TD><TD>Price</TD><TD>Experience</TD></TR><TR><TD>5</TD><TD>2</TD><TD>3</TD></TR><TR><TD>4</TD><TD>2</TD><TD>2</TD></TR><TR><TD>4</TD><TD>1</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I am trying to use Combo / Bar charts to display the average results and highlight the areas which needs improvement. If the Average score is above 3, the bar will be green. If not, it will be red.&nbsp;</P><P>Been exploring with IF and AVG functions but I am having troubles as I have more than just 3 criteria as it will be an extremely long expression. Any advice?</P> Mon, 17 May 2021 15:14:51 GMT https://community.qlik.com/t5/App-Development/Colour-Expression/m-p/1808448#M65839 jeremyyeo93 2021-05-17T15:14:51Z