In SQL statements, it is very useful to use IN clause in the query to compare your value against the provided list of values .
In SQL you can write a query such as
Select ProductName,Revenue from Products
where ProductName IN (‘Chairs’,’Tables’,’CrossArmChairs’);
QlikView does not have IN operator instead QlikView provide match() function to achieve this functionality
I will load an Inline table
Now to load a table with ProductName IN (‘Chairs’,’Tables’,’ArmChairs’) you will use match()
match() does case sensitive comparision. It will return 1 if ProductName = Chairs but will return 0 if ProductName = chairs
For case insenstive comparison, you can use mixmatch()
wildmatch() helps in case insensitive comparison and also permits the use of wild characters
You can use Not preceding Match() to get the ProductNames that are NOT IN the list of values
To load ProductNames which are not ‘Boats’ , you can write
Match() can be used in an expression while creating a chart.
To learn about using Match function to group dimensions in Qlik Sense, visit https://www.learnallbi.com/how-to-create-master-items-in-qlik-sense/