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


Maintaining Color of the Dimensions in QlikView

Recently at work, someone had a problem in assigning a consistent color to the dimension. For example, if  a table consist of Products and Revenue then each Product should maintain a consistent color, irrespective of the selection. Suppose the table is as follows : A pie chart for the above table should maintain consistent colors for the Products i.e. BabyClothes should retain RGB(141,170,203),Sports […]

Continue reading