topic Re: Coloured listbox in QlikView

Coloured listbox

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

How to create an listbox as below which is to coloured,

Thanks..

tresB — Wed, 09 Mar 2016 09:07:22 GMT

Listbox values can't be colored (unless you change the presentation style->LED Checkbox or so), however, an alternate option could be as been suggested here: How to change Background and Font Color in Listboxes?

Chanty4u — Wed, 09 Mar 2016 09:10:04 GMT

chk dis

jagan — Wed, 09 Mar 2016 09:15:17 GMT

It is not possible in list box, but you can use the Straight table display as list box.

Regarsd,

jagan.

nareshthavidishetty — Wed, 09 Mar 2016 10:29:26 GMT

Hi jagan,

If we use straight table it will displays only selected value only it doesn,t show like listbox and also how to get colours in straight table.

Thanks..

MayilVahanan — Wed, 09 Mar 2016 10:34:22 GMT

PFA

Hope it helps

jagan — Thu, 10 Mar 2016 01:00:13 GMT

Hi,

Listbox and Straight table are used for different purposes so don't expect the same features but to some extent we can achieve closer to this.

You can color using the

Dimension or Expression:

Click + -> Background color -> and give expression like below

Pick(Match(FieldName, 'value1', 'Value2', 'Value3',.......), Red(), Green(), Blue(), ....)

The above expression colors value1 in Red, Value2 in Green and Value3 in Blue. You can use RGB() for other colors.

Regards,

Jagan.

engishfaque — Thu, 10 Mar 2016 04:05:34 GMT

Dear Naresh,

You need to create your own extension for desire output.

Kind regards,

Ishfaque Ahmed