Chapter 12. Set Analysis and Point In Time Reporting

Comparing performance metrics over a period of time is one of the most fundamental tasks expected from any BI solution. There are a few ways to deliver these sort of comparisons in QlikView, but the most flexible and dynamic ones involve the use of Set Analysis. Set Analysis, by itself, is a powerful tool that can be used for not only for Point In Time Reporting, but for many other complex calculations.

In this chapter, we will expand on what we've learned from all of the previous chapters, and introduce the following new concepts:

  • Set Analysis and modified record sets
  • Point In Time Reporting
  • Comparative analysis with alternate states

We will approach these topics with the use of some practical examples. ...

Get QlikView for Developers now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.