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

Building a structure of QVD layers

Designing and building ETL layers of QVDs can pay dividends as your use of QlikView grows.

Background

Always try to plan your use of database tables in advance. It's usually much better to start by devising your QVD layers from the outset than to create them later and then having to rework the applications you have already created. QVDs are extremely efficient; as soon as you have the requirement to read the same source data twice or more, one extraction to QVD and then reading (and if necessary, manipulating) a QVD multiple times is generally faster than reading the database table several times into each application that requires it.

How to do it

Consider these scenarios:

  • Scenario 1: A QlikView application that reads six database tables and does some transformation on each of them
  • Scenario 2: A QlikView application that reads six QVD files that require no transformation

If scenario 1 has a failure on the reading of the sixth table for some reason, it could...