Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Partner
Partner

Match multiple on same date

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

  

   

CODEDATE
2418-May-12
5025-Jun-12
2427-Jun-12
7027-Jun-12
1520-Nov-12
2430-Jan-15
7030-Jan-15
783-Feb-15
10015-Mar-15
7028-Mar-15

Message was edited by: Didier Agonvonon

1 Solution

Accepted Solutions
Not applicable

Re: Match multiple on same date

Have a look at this.

View solution in original post

3 Replies
Not applicable

Re: Match multiple on same date

can you please attach the qvw file?

Not applicable

Re: Match multiple on same date

Have a look at this.

View solution in original post

Partner
Partner

Re: Match multiple on same date

Thanks Kumar,

it worked.

Regards

Didier