topic Re: Match function not working in QlikView https://community.qlik.com/t5/QlikView/Match-function-not-working/m-p/1245248#M394941 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Could you upload a sample if possible?</P><P>Thanks!</P></BODY></HTML> Tue, 07 Mar 2017 18:05:51 GMT 2017-03-07T18:05:51Z Match function not working https://community.qlik.com/t5/QlikView/Match-function-not-working/m-p/1245247#M394940 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have the following expression:</P><P>=if(match(chr(39)&amp;'07-Senior'&amp;chr(39),chr(39) &amp; Concat(distinct [Student Level], chr(39) &amp; ', ' &amp; chr(39)) &amp; chr(39)),1,0)</P><P></P><P>Where, Student Level has multiple values, like 07-Senior, 01-Junior and so on. If I select 07-Senior alone as the Student Level, the ablove expression returns 1. But, if I select <SPAN style="font-size: 13.3333px;">07-Senior and 01-Junior, the above expression returns 0, where as it has to return 1.</SPAN></P><P></P><P>Please suggest!</P></BODY></HTML> Tue, 07 Mar 2017 18:03:20 GMT https://community.qlik.com/t5/QlikView/Match-function-not-working/m-p/1245247#M394940 2017-03-07T18:03:20Z Re: Match function not working https://community.qlik.com/t5/QlikView/Match-function-not-working/m-p/1245248#M394941 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Could you upload a sample if possible?</P><P>Thanks!</P></BODY></HTML> Tue, 07 Mar 2017 18:05:51 GMT https://community.qlik.com/t5/QlikView/Match-function-not-working/m-p/1245248#M394941 2017-03-07T18:05:51Z Re: Match function not working https://community.qlik.com/t5/QlikView/Match-function-not-working/m-p/1245249#M394942 <HTML><HEAD></HEAD><BODY><P>Try this instead</P><P></P><P><STRONG>=SubStringCount(Concat(DISTINCT '|' &amp; <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> [Student Level]</SPAN> &amp; '|', ', '), '|<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">07-Senior</SPAN>|')</STRONG></P></BODY></HTML> Tue, 07 Mar 2017 18:05:59 GMT https://community.qlik.com/t5/QlikView/Match-function-not-working/m-p/1245249#M394942 sunny_talwar 2017-03-07T18:05:59Z Re: Match function not working https://community.qlik.com/t5/QlikView/Match-function-not-working/m-p/1245250#M394943 <HTML><HEAD></HEAD><BODY><P>Thank you Sunny. Can you explain me why the expression in the question was not working?</P></BODY></HTML> Tue, 07 Mar 2017 19:44:49 GMT https://community.qlik.com/t5/QlikView/Match-function-not-working/m-p/1245250#M394943 2017-03-07T19:44:49Z