Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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))
Where do i have to put this statement:
"if(GetFieldSelections(FieldName)>0,rgb(255,0,0))"?
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.
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
Hi Larry,
you need to write that "if(GetFieldSelections(FieldName)>0,rgb(255,0,0))" function for 3 list boxes.
The "FieldName" must be changed to match the field for each listbox.
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