topic List Box Background COlor in QlikView

List Box Background COlor

Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: List Box Background COlor

m_woolf — Wed, 09 Mar 2016 18:20:22 GMT

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

Re: List Box Background COlor

Thu, 10 Mar 2016 10:03:53 GMT

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

Re: List Box Background COlor

Thu, 10 Mar 2016 10:13:47 GMT

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.

Re: List Box Background COlor

kushalthakral — Thu, 10 Mar 2016 11:42:13 GMT

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

Re: List Box Background COlor

ramasaisaksoft — Thu, 10 Mar 2016 11:48:53 GMT

Hi Larry,

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

Re: List Box Background COlor

m_woolf — Thu, 10 Mar 2016 13:01:04 GMT

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

Re: List Box Background COlor

amayuresh — Fri, 11 Mar 2016 04:34:30 GMT

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