QlikView Your Business

Chapter 12 Visualizing Inventory Analysis in QlikView

In this chapter, you build the visual part of the Inventory Analysis solution in QlikView. In doing so, we will introduce advanced QlikView visualization techniques. In the process, you will learn how to:

• Use dollar-sign expansions with parameters.
• Present performance as of a past date, using the As of Date technique.
• Use Advanced Aggregation (AGGR) for a number of analytic purposes, including nested aggregation, building histograms, and more.

Developing the Key Measures for Inventory Analysis

This section covers all the preparations and develops some of the basic visualizations that you are already familiar with, only this time within the context of inventory analysis.

Preparing the Environment for Inventory Analysis

Before we delve into the task of building visualizations, let’s describe the main measures that will be used in inventory analysis, walk through the data model, and get a general understanding of the task ahead.

Key Measures for the Inventory Analysis

Chapter 11 described the key metrics that are typically used for Inventory Analysis. Now, let’s define those metrics included in the educational sample and get more detailed in our definitions.

We will be using the following measures for the Inventory Analysis application:

• Current or Historical On Hand Balance—this is a simple sum of the On Hand Balance amount, presented for the current date or for a historical date. We will use date-related conditional flags ...