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
