https://community.qlik.com/t5/Reporting-Service-Alerting/If-statement-Exact-match-on-a-range-of-data/m-p/1972626#M382 <P>Hello I'm trying to creating a filter using an exact match please advise the correct if statement to use</P> <P>&nbsp;</P> <P>If(match(ABCD,('A1','A2','A3','A4',),'Yes','No')</P> <P>Kindly correct my code thank you</P> Fri, 15 Nov 2024 22:03:46 GMT smanas 2024-11-15T22:03:46Z https://community.qlik.com/t5/Reporting-Service-Alerting/If-statement-Exact-match-on-a-range-of-data/m-p/1972626#M382 <P>Hello I'm trying to creating a filter using an exact match please advise the correct if statement to use</P> <P>&nbsp;</P> <P>If(match(ABCD,('A1','A2','A3','A4',),'Yes','No')</P> <P>Kindly correct my code thank you</P> Fri, 15 Nov 2024 22:03:46 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/If-statement-Exact-match-on-a-range-of-data/m-p/1972626#M382 smanas 2024-11-15T22:03:46Z https://community.qlik.com/t5/Reporting-Service-Alerting/If-statement-Exact-match-on-a-range-of-data/m-p/1972671#M383 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/193657">@smanas</a>&nbsp; need to provide brackets correctly . try below one</P> <P>&nbsp;</P> <P><SPAN>If(match(ABCD, 'A1','A2','A3','A4'), 'Yes', 'No')</SPAN></P> Wed, 24 Aug 2022 17:37:10 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/If-statement-Exact-match-on-a-range-of-data/m-p/1972671#M383 Rockstar7 2022-08-24T17:37:10Z