Chart (Listbox- highlight green when selected)

[#1]

Hello,

I have got in my QVW a couple of list boxes created based on charts. The client required when anything is selected in the list, those must be highlighted green.

For the small list boxes I could figure a way.... In the Properties, the node inside the Dimension I have choosen Text Color, and wrote the following expression:

if(Column1= 0, green(),

if(Column1= 1, green(),

if(Column1= 2, green(),

if(Column1= 3, green() ,

if(Column1= 4, green(),Black()

)))))

The problem now, is that have got a list box with several values (up to 100s) and my question is:

Is there way to achieve the same result without having to do all this work for all values in the list?

Ive attached a QVW for an example.

Thank you!!!

[antoniotiman · Accepted solution]

Hi Iuri,

In Your Example.qvw, in Text Color try this

=If(Match(DIAGNOSTIC_CODE,Concat(DIAGNOSTIC_CODE,',')),Green())

Regards,

Antonio

[awhitfield]

Hi Iuri,

why not just use a standard list box and customise the appearance?

See Attached

HTH Andy

[#4]

Hi Andrew,

Thanks for your help.

That was my first ideia, but by using the standard listbox it wont be possible to change the font color when selected.

[#5]

Thats what I was looking for, thank you!

[awhitfield]

Got it now! Glad it's sorted

Andy