Using MATCH function with two parameters

[MattMika]

Dear Community, 

Im new using Qlikview, I have a table which contains 3 columns : the items , the departments and the cities.
at the display level, I want to eliminate departments 2 which belong to cities 900 and 950 and eliminate departments 15 which belong to cities 850 and 860  in the WHERE condition 

Thanks in advance for your help

[hic · Accepted solution]

One easy way is to prepare a flag already in the script:

Load Item, Department, City,
If((Match(Department,2) and Match(City,900,950)) or (Match(Department,15) and Match(City,850,860)),0,1) as IncludeFlag
From <Source> ... ;

Then you can use the following Set expression in any aggregation:
{<IncludeFlag={1}>}

[MattMika]

Thank you! It worked 👌