Book Image

Qlikview Unlocked

Book Image

Qlikview Unlocked

Overview of this book

QlikView Unlocked will provide you with new insights to get the very best from QlikView. This book will help you to develop skills to work with data efficiently. We will cover all the secrets of unleashing the full power of QlikView, which will enable you to make better use of the tool and create better results for future projects. In the course of this book, we will walk you through techniques and best practices that will enable you to be more productive. You will gain quick insights into the tool with the help of short steps called ”keys,” which will help you discover new features of QlikView. Moving on you will learn new techniques for data visualization, scripting, data modeling, and more. This book will then cover best practices to help you establish an efficient system with improved performance. We will also teach you some tricks that will help you speed up development processes, monitor data with dashboards, and so on. By the end of this book, you will have gained beneficial tips, tricks, and techniques to enhance the overall experience of working with QlikView.
Table of Contents (16 chapters)
QlikView Unlocked
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Hidden Image List
Index

Link tables


There are times when it is necessary to have two or more fact tables that have some common dimensions, but they are too big or complex to merge or join in a simple way.

Background

Let's take a typical example of a daily transaction table and a monthly budget/forecast table. They could have common fields that need to be shared as dimensions, such as the Period, Product Type, or Region, but having them in two separate tables would not work.

How to do it

Taking this simple example, we want to be able to connect these tables together so that we can not only select Periods, Product Type and/or Region (Product Type and Region are held in both tables) but also be able to find the forecast figure for the transactions.

Using the following script to read these two tables, you will notice that both alias the Product Type and Region fields so that they don't join, and the script also adds a unique ID field based on the record number (the Date field name is already different in both tables, so...