topic List Box entry in another color in QlikView

List Box entry in another color

danialier — Tue, 18 Mar 2014 15:16:17 GMT

Hello,

I have a List Box with ~10 diferent companies. i want a specific company to be coloured in blue and rest in black as they are already.

is that possible ?

thks,dani

Re: List Box entry in another color

alexandros17 — Tue, 18 Mar 2014 15:22:10 GMT

I think you cannot

Re: List Box entry in another color

MK_QSL — Tue, 18 Mar 2014 15:22:30 GMT

Don't think so there is any color option to show different name in different color.

May be I don't know about it. Let's see what others suggesting.

Re: List Box entry in another color

its_anandrjs — Tue, 18 Mar 2014 15:23:54 GMT

Hi,

I suggest you use any straight table in place of the list box and write a code for background like

if(company = 'Germany' , red( ), Blue( ))

and in expression part put 1 there

Hope this helps

Thanks & Regards

Re: List Box entry in another color

alexandros17 — Tue, 18 Mar 2014 15:25:50 GMT

The straight table collapse when yopu select a value, has a behaviour different from list box

Re: List Box entry in another color

its_anandrjs — Tue, 18 Mar 2014 15:30:49 GMT

Hi,

Yes straight table is not right way but some times it works some change now in place of 1 put '=' is expression

if(company = 'Germany' , Red( ), Blue( ))

Hope this helps

Thanks

Re: List Box entry in another color

stigchel — Tue, 18 Mar 2014 15:33:37 GMT

You can use straight table like in attached sample.qvw

Re: List Box entry in another color

SunilChauhan — Tue, 18 Mar 2014 15:37:54 GMT

see the attached file

hope this helps

Re: List Box entry in another color

stigchel — Tue, 18 Mar 2014 15:38:47 GMT

Not if you use a set expression with e.g. concat({<Company=>} Company)

Re: List Box entry in another color

MK_QSL — Tue, 18 Mar 2014 15:53:20 GMT

What about if I want to select Company 1 and Company 4 together?

Re: List Box entry in another color

MK_QSL — Tue, 18 Mar 2014 15:54:59 GMT

Dear Sunil,

What about selecting two countries together?

Re: List Box entry in another color

SunilChauhan — Tue, 18 Mar 2014 15:58:18 GMT

i dont thing any concern about selection.

Please elaborate your query

Re: Re: List Box entry in another color

stigchel — Tue, 18 Mar 2014 16:17:30 GMT

You're right, non adjacent selections are not possible, the behaviour is different from the listbox. Adjacent selections are possible if you switch the visibilty to the dimension column instead of the expression column(and copy the background color and text color to the dimension). Also if you then use the dropdown select option, you can also do non adjacent selections. See attached.

Re: List Box entry in another color

MK_QSL — Tue, 18 Mar 2014 16:27:54 GMT

Thanks...

Re: List Box entry in another color

bgerchikov — Tue, 18 Mar 2014 16:50:03 GMT

Hi Dani,

you can use image in expression, please review attached.

Thanks!