Using IN clause in QlikView

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 […]

Continue reading