Match multiple on same date

[didierodayo]

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

CODE	DATE
24	18-May-12
50	25-Jun-12
24	27-Jun-12
70	27-Jun-12
15	20-Nov-12
24	30-Jan-15
70	30-Jan-15
78	3-Feb-15
100	15-Mar-15
70	28-Mar-15

Message was edited by: Didier Agonvonon

[#2]

can you please attach the qvw file?

[#3 · Accepted solution]

Have a look at this.

[didierodayo]

Thanks Kumar,

it worked.

Regards

Didier