Problem with setting the background color for an expression ...

[#1]

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.

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!

[lironbaram · Accepted solution]

hei

attach is an example

[#3]

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 : =if ([country] = 'USA', LightGreen(), LightGray()) . 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

[lironbaram]

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

i am using maxstring , to unable use of set analysis