O'Reilly logo

QlikView Unlocked by Andrew Dove, Roger Stone

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required