topic Re: activate font color not changing on multiple values selection in QlikView

activate font color not changing on multiple values selection

Mon, 07 Sep 2015 14:58:02 GMT

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

Re: activate font color not changing on multiple values selection

Anonymous — Mon, 07 Sep 2015 15:02:11 GMT

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

Re: activate font color not changing on multiple values selection

Mon, 07 Sep 2015 15:08:54 GMT

thanx linder but still text color not changing

Re: activate font color not changing on multiple values selection

Anonymous — Mon, 07 Sep 2015 15:28:39 GMT

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)

Re: activate font color not changing on multiple values selection

Mon, 07 Sep 2015 15:48:09 GMT

Color change also working for you?

Re: activate font color not changing on multiple values selection

Mon, 07 Sep 2015 15:52:46 GMT

it works thanx a lot for the solution