topic Re: changing the text color using IF & match in QlikView

changing the text color using IF & match

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

Hi,

the following code is not working, what can I do to get it to work?

=if(match([Tree Name],[Tree Name Group]), RGB (128,0,0),RGB(0,0,0))

Re: changing the text color using IF & match

sinanozdemir — Fri, 05 Aug 2016 13:22:19 GMT

Try it like the below:

=if(match([Tree Name],chr(39) & [Tree Name Group] & chr(39)), RGB (128,0,0),RGB(0,0,0))

Hope this helps

Re: changing the text color using IF & match

Anonymous — Fri, 05 Aug 2016 13:30:51 GMT

thanks for the reply but it is not working

Re: changing the text color using IF & match

krishnacbe — Fri, 05 Aug 2016 13:52:46 GMT

Share some sample data or app. so that we can help you better

Re: changing the text color using IF & match

krishnacbe — Fri, 05 Aug 2016 13:54:11 GMT

If there are more that one possible values for [Tree Name Group], then your expression will not work.

Re: changing the text color using IF & match

Anonymous — Fri, 05 Aug 2016 13:56:29 GMT

yes,there are more that one possible values for [Tree Name Group. So, what should I do instead?

Re: changing the text color using IF & match

Mark_Little — Fri, 05 Aug 2016 13:58:53 GMT

Hi,

Not sure where you are doing this, but if i was writing it would just do it like

If([Tree Name] = [Tree Name Group], RGB (128,0,0),RGB(0,0,0))

Mark

Re: changing the text color using IF & match

Anonymous — Fri, 05 Aug 2016 14:09:01 GMT

Hi Mark,

thanks for your help. this is where I am doing this:

Re: changing the text color using IF & match

antoniotiman — Fri, 05 Aug 2016 14:12:56 GMT

Hi,

try

If(Match([Tree Name] , $(=Concat(DISTINCT Chr(39)&[Tree Name Group]&Chr(39),','))), RGB (128,0,0),RGB(0,0,0))

Owever this works if [Tree Name] -> 1 Value

Regrds,

Antonio

Re: changing the text color using IF & match

Anonymous — Fri, 05 Aug 2016 14:13:01 GMT

It is still not working

Re: changing the text color using IF & match

Anonymous — Fri, 05 Aug 2016 14:20:21 GMT

sorry, no joy, still not working

Re: changing the text color using IF & match

antoniotiman — Fri, 05 Aug 2016 15:39:18 GMT

Hi,

The first paramether of Match() function must have 1 value.

If [Tree Name] has many values it is Null().

You can try MinString([Tree Name]) or MaxString(), but I'm not sure this is what Your expecting result.

Re: changing the text color using IF & match

antoniotiman — Fri, 05 Aug 2016 15:57:36 GMT

Try

WildMatch($(=Concat(DISTINCT [Tree Name],'')) , $(=Concat(DISTINCT Chr(39)&Chr(42)&[Tree Name Group]&Chr(42)&Chr(39),',')))

Instead of Match() expression

Re: changing the text color using IF & match

Anonymous — Fri, 05 Aug 2016 16:40:18 GMT

sorry still not working

Re: changing the text color using IF & match

antoniotiman — Fri, 05 Aug 2016 17:21:51 GMT

I'm sorry, this is the best I can do with Match/WildMatch.

If You want uncheck "Correct Answer" and You hope someone else You provides correct answer.

Regards,

Antonio

Re: changing the text color using IF & match

sunny_talwar — Fri, 05 Aug 2016 17:26:34 GMT

How about this:

If(Count({<[Tree Name] = p([Tree Name Group])>} [Tree Name]) > 0, RGB(128,0,0), RGB(0,0,0))

Re: changing the text color using IF & match

Anonymous — Mon, 08 Aug 2016 13:33:40 GMT

thanks for trying but I don't know why it is not highlighting the names in red

Re: changing the text color using IF & match

Anonymous — Mon, 08 Aug 2016 13:40:31 GMT

thanks