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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Searching field for specific word

I would like to highlight the background colour of a dimension value when it includes the word 'primary' e.g. Williamston Primary School.  I have been trying to change the background colour on my dimension using the following expression -

=If([School Name]='*Primary', Yellow(),)

But it doesn't work.  What should I use instead of the *

Thanks

Greg

1 Solution

Accepted Solutions
sunny_talwar

May be you need an * at the end too?

=If(WildMatch([School Name], '*Primary*'), Yellow())

View solution in original post

5 Replies
sunny_talwar

May be use WildMatch

=If(WildMatch([School Name], '*Primary'), Yellow())

Anonymous
Not applicable
Author

Thanks but it didn't work.

sunny_talwar

May be you need an * at the end too?

=If(WildMatch([School Name], '*Primary*'), Yellow())

Anonymous
Not applicable
Author

Thanks.  That worked!

sunny_talwar

Superb