Chapter 12. Advanced Data Transformation

In this chapter we will dive into advanced transformation functions and techniques available through QlikView's extraction engine. This will allow you, as a developer, to finely process the source data and turn it into a clean design, while at the same time keeping an efficient script.

The goals of this chapter are:

• To provide an overview of the most commonly used data architectures that can ease QlikView's development and administration

• To describe the available functions for data aggregation

• To learn how to take advantage of some of QlikView's most powerful data transformation functions.