Match multiple on same date

didierodayo — Thu, 28 Jul 2016 02:25:07 GMT

HELLO,

I have the expression below on a line chart background to change the colors.

if(match(CODE, '24','70'), RED(), BLUE())

This is working BUT I am getting a BLUE color on days where they were 24 and 70 on the same date.

I need the expression to give me red even if it finds 24 and 70 on the same date. So 27-Jun-12 and 30-Jan-15 should also be highlighted RED().

It is currently coloring those codes Blue. I appreciate your assistance.

Thanks

Message was edited by: Didier Agonvonon

Re: Match multiple on same date

Thu, 28 Jul 2016 02:29:41 GMT

can you please attach the qvw file?

Thu, 28 Jul 2016 02:40:22 GMT

Have a look at this.

didierodayo — Thu, 28 Jul 2016 02:58:23 GMT

Thanks Kumar,

it worked.

Regards

Didier