topic Re: Colour coding/ formatting an expression in QlikView https://community.qlik.com/t5/QlikView/Colour-coding-formatting-an-expression/m-p/459688#M486589 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Thanks but </P><P>the fields it is missing out isn't null it contains 'B'. all other fields containg 'B' are getting formatted</P></BODY></HTML> Fri, 22 Feb 2013 13:54:28 GMT 2013-02-22T13:54:28Z Colour coding/ formatting an expression https://community.qlik.com/t5/QlikView/Colour-coding-formatting-an-expression/m-p/459686#M486587 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am colour coding an expression that returns a string value using a pick(match( statement)).</P><P>This is being done at the expression level by formatting the background.</P><P>however it seems to be missing out some random values. </P><P>For example it will colour code 'B' with the corresponding colour in one cell but will miss it out in another cell. I have checked and there are no spaces contained in the string comparisons. </P><P>Has any one come across this problem before or have any suggestions in what I can do?</P><P></P><P>Thankyou</P></BODY></HTML> Thu, 21 Feb 2013 16:47:23 GMT https://community.qlik.com/t5/QlikView/Colour-coding-formatting-an-expression/m-p/459686#M486587 2013-02-21T16:47:23Z Re: Colour coding/ formatting an expression https://community.qlik.com/t5/QlikView/Colour-coding-formatting-an-expression/m-p/459687#M486588 <HTML><HEAD></HEAD><BODY><P>If The "Missed" cell contains null values it is a normal behaviour. If this you must manage data ...</P><P></P><P>Let me know</P></BODY></HTML> Thu, 21 Feb 2013 17:11:31 GMT https://community.qlik.com/t5/QlikView/Colour-coding-formatting-an-expression/m-p/459687#M486588 alexandros17 2013-02-21T17:11:31Z Re: Colour coding/ formatting an expression https://community.qlik.com/t5/QlikView/Colour-coding-formatting-an-expression/m-p/459688#M486589 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Thanks but </P><P>the fields it is missing out isn't null it contains 'B'. all other fields containg 'B' are getting formatted</P></BODY></HTML> Fri, 22 Feb 2013 13:54:28 GMT https://community.qlik.com/t5/QlikView/Colour-coding-formatting-an-expression/m-p/459688#M486589 2013-02-22T13:54:28Z