Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

activate font color not changing on multiple values selection

i have a button which selects all values in country field ,i am setting action select in field  Country '(INDIA|US|UK*)',it selects correctly, but when i apply background color calculation on activation with if(Region='(INDIA|US|UK*)',LightRed(),black()),it does not work?? any idea

Tags (1)
1 Solution

Accepted Solutions
hrlinder
Honored Contributor

Re: activate font color not changing on multiple values selection

sorry, I didnot try it

what i tried now works in my test

=if (GetFieldSelections(Region)='INDIA, US, UK',Lighred();..)

I guess there is a space between , and next character

and it might depend on the order how you select the regions (if you do by Action it should work)

5 Replies
hrlinder
Honored Contributor

Re: activate font color not changing on multiple values selection

you Need to concat the regions and test to the result

if (concat(Region,'|')='INDIA|US|UK',LightRed(),...

when you select the regions with '(INDIA|US|UK*) each Region will be selected, bit not within 1 string

Not applicable

Re: activate font color not changing on multiple values selection

thanx linder but still text color not changing

hrlinder
Honored Contributor

Re: activate font color not changing on multiple values selection

sorry, I didnot try it

what i tried now works in my test

=if (GetFieldSelections(Region)='INDIA, US, UK',Lighred();..)

I guess there is a space between , and next character

and it might depend on the order how you select the regions (if you do by Action it should work)

Not applicable

Re: activate font color not changing on multiple values selection

Color change also working for you?

Not applicable

Re: activate font color not changing on multiple values selection

it works thanx a lot for the solution

Community Browser