Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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}>}
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}>}
Thank you! It worked 👌