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

Incremental loads and performance

Most data sources grow over time, and when dealing with large volumes of data, the time taken to reload documents increases along with the size of the data.

Background

The time taken to read all the data from a file or database increases as the size of the data grows, especially if this source is on the wrong side of a firewall or on an older, slower network infrastructure.

One way to reduce the time taken for the reload is to only load from source data that has been added or changed, reducing the amount of data retrieved from the source.

The less data that needs to pulled from a database, spreadsheet, or text file, the quicker the reload will be. Reading the bulk of the data from a QVD file is substantially faster.

How to do it

Incremental load is a technique whereby data is read from a source and stored on a local drive as a QVD file. Subsequent loads are first done from the QVD file; then, only the new (or updated) data is read from the source and finally...