Data Modeling in QlikView is a very broad concept. QlikView is a wonderful tool and it gives you whole gamut of functionalities to perfect your data model. With this blog my intention is to give QlikView beginners an insight into QlikView data modeling. I have received lot of emails from BI developers who say that […]
Learn QlikView
Dynamic colors in QlikView
You can create a very interactive application where clicking on a specific color will change the colors of all the charts and objects in your application. Something similar to the video above and the picture below. I will show you the approach i took for this solution. In this excercise you can also learn How […]
Power of Tags in QlikView
Tags can be very powerful in QlikView application development. Tag function provides a way to assign Tags to a field. Fields not present in the document are ignored. Tags provide a way to group dimensions and measures together while creating charts. There are different kinds of system tags but here we will discuss $dimension and […]
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 […]
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 […]