Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
rustyfishbones
Master II
Master II

Changing Text Object Color with Multiple Select in Field

Hi All,

I have the following expression

File.png

I have a Text object with an Action of Select in Field, and it looks like this

2013-10-04_0951.png

But when I click the Text Object to select the fields, the background color should turn to the $(color.green)

but it does not seem to be working

Any help would be great

1 Solution

Accepted Solutions
jagannalla
Partner - Specialist III
Partner - Specialist III

Please check the attached file..

Just use the condition as

=if(WildMatch(GetFieldSelections(File,'|'),'(.P|.R|.I|.W|.D|.WRX)'),Blue(),Green())

Hope it helps you

Cheers!!

Jagan

View solution in original post

16 Replies
sujeetsingh
Master III
Master III

Just to check call this variable color.green in another text box and then see it value .

clarify the value is what you want .

Whether you want the color to come ,where you have written this expression .

Can you please send a sample .

tresesco
MVP
MVP

Try removing the double quotes in the search string like:

(.P|.R|.I|.W|.D|.WRX)

rustyfishbones
Master II
Master II
Author

I have tried both of those suggestions but with no luck.

It will select the fields (.P|.R|.I|.W|.D|.WRX) perfectly

bjut the color just wont change, It's working for all other Select in Fields when I am selecting a single value.

So it must be something else

Regards

Alan

tresesco
MVP
MVP

You have to modify the expression for background color like:

If(GetFieldSelections(File,'|')='(.P|.R|.I|.W|.D|.WRX)' , greeen(), white())

Not applicable

Hi,

Try like this

If(GetFieldSelections(File,'|')='(.P|.R|.I|.W|.D|.WRX)' , RGB(0,0,0),RGB(255,255,0))

rustyfishbones
Master II
Master II
Author

Hi guys,

I have tried your suggestions but it's still now working

I will try post a sample

rustyfishbones
Master II
Master II
Author

Hi Guys,

here is a sample file.

As you wil see, the button for 'All' selects the correct fields but does not turn blue like the other 2 buttons when they are selected

Hope you can help

Regards

Alan

jagannalla
Partner - Specialist III
Partner - Specialist III

Please check the attached file..

Just use the condition as

=if(WildMatch(GetFieldSelections(File,'|'),'(.P|.R|.I|.W|.D|.WRX)'),Blue(),Green())

Hope it helps you

Cheers!!

Jagan

rustyfishbones
Master II
Master II
Author

Hi All,

That works, thanks for your help guys

Alan