QlikView Your Business

Chapter 10 Developing a Data Load Script for Profitability Analysis

In this chapter, you’ll learn how to build the data model for the Profitability Analysis application. In the process of doing so, the chapter continues to describe QlikView data load scripting. Building on the foundation laid out in Chapter 7, this chapter describes more advanced scripting techniques. You will learn how to:

• Use QlikView Data (QVD) files in a separate data layer.
• Use variables and script control statements.
• Create and use a library of common routines.
• Use mapping for data cleansing and to fetch a single field from another table without joining.
• Create a Master Calendar.
• Deal with slowly changing dimensions.

Creating a QVD Data Layer

This section introduces QVD files and describes various techniques for loading database tables and storing them as QVD files. In the process of building the QVD Generators, we describe how to use QlikView variables and script control statements.

Why Do You Need a Separate Data Layer?

At our fictional company, Q-Tee Brands, the QlikView development team was celebrating. The Sales Analysis application was a huge success, and that is why the business immediately requested the team to develop the next dashboard—the Profitability Analysis.

In the process of gathering data for the Profitability Analysis, the team discovered that many of the same tables used for the Sales Analysis will be needed for the new dashboard. They will have to load Sales data, Products, and ...