Master Calendar in QlikView

In any Dashboard,Time is an important factor. Users will always be interested in viewing the data by time period and also will be interested in performing comparitive analysis between 2 time periods. In a data warehouse, a Time dimension table is usually present, which joins to the fact table and produces results.In some situations, time […]

Continue reading


QlikView – Resolving Synthetic keys

Synthetic table and Synthetic keys gets created when there are more than one common fields between the 2 or more tables. QlikView associates tables based on the common field names in the tables and if there is more than one common field then QlikView creates  synthetic tables.  Synthetic keys are not beneficial in datamodel because they are resource intensive […]

Continue reading


QlikView – Connecting to excel file

In QlikView you can connect to variety of datasources. QlikView can connect to ODBC,OLEDB,XML datasources. You can also connect to cloud datasources like SalesForce.com. In this excercise i want to show you how to connect to an excel file in QlikView. To learn how to load excel file in QlikSense visit Creating first QlikSense application Steps: Create […]

Continue reading


QlikView Overview

        Traditional Business Intelligence tools are unable to meet the fast paced data requirements and customer expectations. These BI tools suffered from lengthy development time,absence of data transformation environment and non-intuitive visualizations . Users have to go to multiple reports to answer a single question.Data was still trapped in layers and data discovery was not possible. […]

Continue reading