topic Re: Compare two strings (One from field selections and another from a variable) in QlikView https://community.qlik.com/t5/QlikView/Compare-two-strings-One-from-field-selections-and-another-from-a/m-p/37129#M6258 <HTML><HEAD></HEAD><BODY><P>Thanks Krishna.</P></BODY></HTML> Fri, 13 Jul 2018 02:22:11 GMT balarajuhari 2018-07-13T02:22:11Z Compare two strings (One from field selections and another from a variable) https://community.qlik.com/t5/QlikView/Compare-two-strings-One-from-field-selections-and-another-from-a/m-p/37127#M6256 <HTML><HEAD></HEAD><BODY><P>Hi Giants, I have a scenario where I want to populate a variable(vEUCategory) such that if any of the selected values in a field (Country) matches with any of the list in a variable (vEUCountries) then 1 else 0. How can i achieve this. I know we can achieve SQL's IN operator functionality in Qlikview using Match function. But here i need to compare multiple values (selections in Country field) with the list of values(EU Countries) in a variable (vEUCountries). I tried below, but not working when multiple countries (both EU and Non-EU) are selected.</P><P></P><P>vEUCategory=if(Match(subfield(Concat(Country, ','), ',', 1),$(=vNonEUCountries))=0 and</P><P> Match(subfield(Concat(Country, ','), ',', 1),$(=vEUCountries))&gt;0),1,0).</P><P></P><P></P><P>Happy Learning,</P><P>Hari</P></BODY></HTML> Fri, 16 Mar 2018 04:47:32 GMT https://community.qlik.com/t5/QlikView/Compare-two-strings-One-from-field-selections-and-another-from-a/m-p/37127#M6256 balarajuhari 2018-03-16T04:47:32Z Re: Compare two strings (One from field selections and another from a variable) https://community.qlik.com/t5/QlikView/Compare-two-strings-One-from-field-selections-and-another-from-a/m-p/37128#M6257 <HTML><HEAD></HEAD><BODY><P>Check this out.</P><P></P><P><IMG alt="1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/196618_1.PNG" style="height: auto;" /><IMG alt="2.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/196622_2.PNG" style="height: auto;" /></P><P></P><P>Hope that helps.</P></BODY></HTML> Sat, 17 Mar 2018 06:13:47 GMT https://community.qlik.com/t5/QlikView/Compare-two-strings-One-from-field-selections-and-another-from-a/m-p/37128#M6257 Qrishna 2018-03-17T06:13:47Z Re: Compare two strings (One from field selections and another from a variable) https://community.qlik.com/t5/QlikView/Compare-two-strings-One-from-field-selections-and-another-from-a/m-p/37129#M6258 <HTML><HEAD></HEAD><BODY><P>Thanks Krishna.</P></BODY></HTML> Fri, 13 Jul 2018 02:22:11 GMT https://community.qlik.com/t5/QlikView/Compare-two-strings-One-from-field-selections-and-another-from-a/m-p/37129#M6258 balarajuhari 2018-07-13T02:22:11Z