Databases Reference
In-Depth Information
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. Given the
harshness of the syntax we are going to use, and the complexity of the expressions
that can be built with Set Analysis, we recommend you to have a lot of patience and
dedication to the subject at hand. Even with the best reference material, Set Analysis
can take a while to master—so don't lose heart!
The magic of Set Analysis
We will now introduce one of the most powerful tools you, as a developer, have at
your disposal when creating QlikView documents. We must say upfront that, as
with anything, the excessive use of Set Analysis in chart expressions can yield poor
performance or low response times. However, we should also know that, when used
effectively, it can have a positive impact in both performance and user experience.
