topic Re: Chart (Listbox- highlight green when selected) in QlikView

Chart (Listbox- highlight green when selected)

Thu, 21 May 2015 09:18:45 GMT

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!!!

Re: Chart (Listbox- highlight green when selected)

antoniotiman — Thu, 21 May 2015 09:32:54 GMT

Hi Iuri,

In Your Example.qvw, in Text Color try this

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

Regards,

Antonio

Re: Chart (Listbox- highlight green when selected)

awhitfield — Thu, 21 May 2015 09:33:59 GMT

Hi Iuri,

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

See Attached

HTH Andy

Re: Chart (Listbox- highlight green when selected)

Thu, 21 May 2015 10:46:47 GMT

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.

Re: Chart (Listbox- highlight green when selected)

Thu, 21 May 2015 10:49:34 GMT

Thats what I was looking for, thank you!

Re: Chart (Listbox- highlight green when selected)

awhitfield — Thu, 21 May 2015 10:56:17 GMT

Got it now! Glad it's sorted

Andy