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 […]
Author: Chandraish Sinha
Role playing dimensions in QlikView
Role playing dimension is used when a dimension table is reused to join with a fact table more than once. A classic example of a role playing dimension can be a Time Dimension which joins with a Fact table. This Fact table contains OrderDate,ShipDate,ReceiveDate etc. To get these dates you will create just one table for TimeDim in […]
Share this:
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 […]
Share this:
Deploying QlikView Dashboard on the Server
QlikView Development LifeCycle Organizations may follow different development lifecycle depending on the organizations requirements,size and development methodology but most of the organizations utilising QlikView may follow a similar development style. I am writing this blog to give novice developers an idea on how QlikView environments work. QlikView development Life Cycle involve : – Interacting with […]
Share this:
QlikView Client Access Licenses – CALs
All users need license from the QlikView Server to access or open a document/qvw. This license is referred as CALs i.e. Client Access License. This license is required when user or developer access qvw in QlikView desktop or through Access point url. CALs are acquired with the purchase of the QlikView Server and therefore are server […]
: