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 ...

Get QlikView Unlocked now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.