Book Image

Qlikview Unlocked

By : Roger Stone, Andrew Dove
Book Image

Qlikview Unlocked

By: Roger Stone, Andrew Dove

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 (11 chapters)
9
A. Hidden Image List
10
Index

Data islands, single calendars, and set analysis

Quite often within QlikView applications, it is necessary to use the same selection criteria over a number of fields. For example, you may want to have a date selection, which selects Date Ordered on one chart and Date Received on another chart.

Background

Previously, we mentioned circular references. One way in which these are created is when there is a Date selection in multiple date fields. The multiple dates exist so that we can produce charts, for example, using Date Ordered on one chart and Date Received on another.

We could avoid the circular reference by having two selection boxes, but we could then have the issue that only selected records fit with both selections.

The alterative to this is to use the Data Island approach.

How to do it

The way around this is to have a Data Island, where a table is created with no connections to any other table. Have a look at the following script:

How to do it

Here, we created a MasterCalendar table using the earliest...