topic Searching field for specific word in QlikView

Searching field for specific word

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Searching field for specific word

sunny_talwar — Wed, 29 Mar 2017 12:56:22 GMT

May be use WildMatch

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

Re: Searching field for specific word

Anonymous — Wed, 29 Mar 2017 13:04:49 GMT

Thanks but it didn't work.

Re: Searching field for specific word

sunny_talwar — Wed, 29 Mar 2017 13:05:45 GMT

May be you need an * at the end too?

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

Re: Searching field for specific word

Anonymous — Wed, 29 Mar 2017 13:07:59 GMT

Thanks. That worked!

Re: Searching field for specific word

sunny_talwar — Wed, 29 Mar 2017 13:08:12 GMT

Superb