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 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