Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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

16 Replies
rustyfishbones
Master II
Master II
Author

Hi Jagan,

One final question, how can I get the color to change for the excluded files

so I have select in field (.P|.R|.I|.W|.D|.WRX) and then Select Excluded

but how to get a new button to change color for all selections not in (.P|.R|.I|.W|.D|.WRX)

Thanks

Alan

Not applicable

Allan;

Try changing the expression of the action "select field" to:

(. P |. I) without the double quotes

Not applicable

inverting the expression passed by Jagan

= if (not WildMatch (GetFieldSelections (File, '|'), '(. P |. R |. I |. W |. D |. WRX)'), blue (), green ())

rustyfishbones
Master II
Master II
Author

Thanks Claudio,

That works fine

I have used NOT WILDMATCH before, I just tend to forget these things if I have not used them in a while

Thanks again

jagannalla
Partner - Specialist III
Partner - Specialist III

U can go with Claudio expr for exclude values

rustyfishbones
Master II
Master II
Author

Thanks Jagan.

However, although it does color the background based on the NOT part being added

It also continues to highlight if I select some of the other buttons

see below example, I selected .wrx, but it also highlights aof.

If I select aof first it's fine, but if I select .P|.R|.I|.W|.D|.WRX it also highlights aof

test_001.png

Not applicable

See the attachement.