topic Colours in Chart in QlikView https://community.qlik.com/t5/QlikView/Colours-in-Chart/m-p/1443123#M459033 <HTML><HEAD></HEAD><BODY><P>Hi There</P><P></P><P>How do you keep the colours of a chart dynamic.</P><P>I want good to always be green average amber and bad red.</P></BODY></HTML> Thu, 09 Nov 2017 07:48:13 GMT bimanbeginner 2017-11-09T07:48:13Z Colours in Chart https://community.qlik.com/t5/QlikView/Colours-in-Chart/m-p/1443123#M459033 <HTML><HEAD></HEAD><BODY><P>Hi There</P><P></P><P>How do you keep the colours of a chart dynamic.</P><P>I want good to always be green average amber and bad red.</P></BODY></HTML> Thu, 09 Nov 2017 07:48:13 GMT https://community.qlik.com/t5/QlikView/Colours-in-Chart/m-p/1443123#M459033 bimanbeginner 2017-11-09T07:48:13Z Re: Colours in Chart https://community.qlik.com/t5/QlikView/Colours-in-Chart/m-p/1443124#M459034 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P></P><P>pfa</P><P></P><P>add <STRONG>pick(match(Status,'Good','Average','Bad'),1,2,3)</STRONG> in the sort tab </P><P></P><P></P><P>regards</P><P>Pradosh</P></BODY></HTML> Thu, 09 Nov 2017 07:55:44 GMT https://community.qlik.com/t5/QlikView/Colours-in-Chart/m-p/1443124#M459034 pradosh_thakur 2017-11-09T07:55:44Z Re: Colours in Chart https://community.qlik.com/t5/QlikView/Colours-in-Chart/m-p/1443125#M459035 <HTML><HEAD></HEAD><BODY><P>Hi Pradosh</P><P></P><P>In a case like the attached model when there is no data for the one month 201704 for average then it is not dynamic...</P></BODY></HTML> Thu, 09 Nov 2017 08:23:24 GMT https://community.qlik.com/t5/QlikView/Colours-in-Chart/m-p/1443125#M459035 bimanbeginner 2017-11-09T08:23:24Z Re: Colours in Chart https://community.qlik.com/t5/QlikView/Colours-in-Chart/m-p/1443126#M459036 <HTML><HEAD></HEAD><BODY><P>presentation -&gt; uncheck supress zero values</P></BODY></HTML> Thu, 09 Nov 2017 08:56:14 GMT https://community.qlik.com/t5/QlikView/Colours-in-Chart/m-p/1443126#M459036 pradosh_thakur 2017-11-09T08:56:14Z Re: Colours in Chart https://community.qlik.com/t5/QlikView/Colours-in-Chart/m-p/1443127#M459037 <HTML><HEAD></HEAD><BODY><P>Try this instead</P><P></P><P>check the back ground color of the expression</P><P></P><P></P><P>regards</P><P>Pradosh</P></BODY></HTML> Thu, 09 Nov 2017 09:00:59 GMT https://community.qlik.com/t5/QlikView/Colours-in-Chart/m-p/1443127#M459037 pradosh_thakur 2017-11-09T09:00:59Z Re: Colours in Chart https://community.qlik.com/t5/QlikView/Colours-in-Chart/m-p/1443128#M459038 <HTML><HEAD></HEAD><BODY><P>Thank you that works Perfect!!!</P></BODY></HTML> Thu, 09 Nov 2017 09:08:17 GMT https://community.qlik.com/t5/QlikView/Colours-in-Chart/m-p/1443128#M459038 bimanbeginner 2017-11-09T09:08:17Z