Compare two strings (One from field selections and another from a variable)

[balarajuhari]

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.

vEUCategory=if(Match(subfield(Concat(Country, ','), ',', 1),$(=vNonEUCountries))=0 and

Match(subfield(Concat(Country, ','), ',', 1),$(=vEUCountries))>0),1,0).

Happy Learning,

Hari

[Qrishna]

Check this out.

Hope that helps.

[balarajuhari]

Thanks Krishna.