topic Problem with setting the background color for an expression ... in QlikView https://community.qlik.com/t5/QlikView/Problem-with-setting-the-background-color-for-an-expression/m-p/246187#M93836 <HTML><HEAD></HEAD><BODY><P> the reason is country is the field you choose in the list box so the actualy it holds the values you want to exclude so it returns null to all the countries in the table</P><P>i am using maxstring , to unable use of set analysis</P></BODY></HTML> Thu, 08 Sep 2011 09:59:00 GMT lironbaram 2011-09-08T09:59:00Z Problem with setting the background color for an expression ... https://community.qlik.com/t5/QlikView/Problem-with-setting-the-background-color-for-an-expression/m-p/246184#M93833 <HTML><HEAD></HEAD><BODY><P>Hi, i met with an issue when trying to set the background color for an expression. Please refer to the attached QVW file for further information. In the QVW, i set the background color of the expression to show light green for country = 'USA' while others will show in light grey.</P><P></P><P>In addition to the straight table, i also have a list box which let the users to choose those countries they would like to exclude from the straight table. The problem is when i make any selection to the list box, the color assignment for the expression seems to not working anymore. Kindly please let me know how to solve this issue. Thanks so much!</P></BODY></HTML> Thu, 08 Sep 2011 08:02:39 GMT https://community.qlik.com/t5/QlikView/Problem-with-setting-the-background-color-for-an-expression/m-p/246184#M93833 2011-09-08T08:02:39Z Re: Problem with setting the background color for an expression ... https://community.qlik.com/t5/QlikView/Problem-with-setting-the-background-color-for-an-expression/m-p/246185#M93834 <HTML><HEAD></HEAD><BODY><P> hei</P><P>attach is an example</P></BODY></HTML> Thu, 08 Sep 2011 08:10:44 GMT https://community.qlik.com/t5/QlikView/Problem-with-setting-the-background-color-for-an-expression/m-p/246185#M93834 lironbaram 2011-09-08T08:10:44Z Problem with setting the background color for an expression ... https://community.qlik.com/t5/QlikView/Problem-with-setting-the-background-color-for-an-expression/m-p/246186#M93835 <HTML><HEAD></HEAD><BODY><P>Hi Liron, thanks again for your brilliant solution!!! Would you mind to explain it to me why i can't just write the statement like this : =<SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;"> (</SPAN><SPAN style="color: #800000; font-size: 8pt;">[country]</SPAN><SPAN style="font-size: 8pt;"> = 'USA', </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">LightGreen</SPAN><SPAN style="font-size: 8pt;">(), </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">LightGray</SPAN><SPAN style="font-size: 8pt;">())</SPAN> . Why it has to be written using set expression and why you are using 'maxstring'? Sorry for taking your time and i appreciate your help very much <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /><SPAN style="font-size: 8pt;"></SPAN></P><P><SPAN style="font-size: 8pt;"> </SPAN></P><P><SPAN style="font-size: 8pt;"> </SPAN></P><P></P><P><SPAN style="font-size: 8pt;"> </SPAN></P></BODY></HTML> Thu, 08 Sep 2011 09:06:03 GMT https://community.qlik.com/t5/QlikView/Problem-with-setting-the-background-color-for-an-expression/m-p/246186#M93835 2011-09-08T09:06:03Z Problem with setting the background color for an expression ... https://community.qlik.com/t5/QlikView/Problem-with-setting-the-background-color-for-an-expression/m-p/246187#M93836 <HTML><HEAD></HEAD><BODY><P> the reason is country is the field you choose in the list box so the actualy it holds the values you want to exclude so it returns null to all the countries in the table</P><P>i am using maxstring , to unable use of set analysis</P></BODY></HTML> Thu, 08 Sep 2011 09:59:00 GMT https://community.qlik.com/t5/QlikView/Problem-with-setting-the-background-color-for-an-expression/m-p/246187#M93836 lironbaram 2011-09-08T09:59:00Z