topic Using MATCH function with two parameters in QlikView

Using MATCH function with two parameters

MattMika — Wed, 20 Jul 2022 10:28:53 GMT

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

Re: Using MATCH function with two parameters

hic — Wed, 20 Jul 2022 11:23:58 GMT

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}>}

Re: Using MATCH function with two parameters

MattMika — Wed, 20 Jul 2022 12:50:12 GMT

Thank you! It worked 👌