In Qlikview it is always advisable to minimize the number of tables in the data model. Mapping Tables are used in QlikView to clean up the data model. Tables with just 2 columns can be removed and columns of that table can be mapped to another table. Mapping tables are stored in a separate area […]
Month: May 2013
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 […]
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 […]
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. […]