List Box Background COlor

[#1]

Hi. Is there a way to make those listboxes with selection done recognizable?

Example: Let's say we have 3 listboxes, i.e. Country, Religion, and Gender.

If I select United states for country, and Christian for Religion, I want those two listboxes to have common color of border/background.
Is there a way to do that?

[m_woolf]

QlikView automatically makes listboxes with selections recognizable by highlighting the selections in green.

You can customize the border colors and caption background colors by using a calculated color something like:

if(GetFieldSelections(FieldName)>0,rgb(255,0,0))

[#3]

Where do i have to put this statement:
"if(GetFieldSelections(FieldName)>0,rgb(255,0,0))"?

[#4]

Oh, got it. But the problem is, if i made a selection on other listbox, the background/border color of the previous listbox changes back to default.

What i want is to have common backgorund for all listbox where selection is made.

[kushalthakral]

Hi Larry

You can write expression like below for all list boxes

if(GetFieldSelections(FieldName1)>0,rgb(255,0,0)) or if(GetFieldSelections(FieldName2)>0,rgb(255,0,0)) or

if(GetFieldSelections(FieldName3)>0,rgb(255,0,0))

Regards

Kushal Thakral

[ramasaisaksoft]

Hi Larry,

you need to write that "if(GetFieldSelections(FieldName)>0,rgb(255,0,0))" function for 3 list boxes.

[m_woolf]

The "FieldName" must be changed to match the field for each listbox.

[amayuresh]

Try this

set Background Color of Region List box for Inactive and Active Caption with below expression

=if(GetSelectedCount(Region)>0,RGB(255,102,102))

This will set the Border & Title Background Color of List box