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

Preceding load on preceding load

Within the QlikView scripting language, there is the ability to write Load statements on top of each other; such statements are known as preceding loads. This is quite a useful feature as it allows additional script to be applied without a lot of extra work.

However, there is quite a bit of processing overhead involved when you use this feature, and in most cases, it is more efficient to reload the table again (using resident) than it is to use preceding load on preceding load. Alternatively, if the reason for the preceding load on preceding load is to reuse a calculated field, it can be more efficient to reproduce the calculation again.

Consider the following example:

Product_Source:
LOAD *,
  Price + VAT as TotalPrice
;
LOAD [Product Code],  
     Price,
     Price * 0.20 as VAT
FROM 

Here, we calculated the VAT figure, stored it as a field, and then in the next part of the LOAD, we added the VAT figure to the price, giving us a TotalPrice field. This is fairly...