Chapter 3. Set Analysis

In this chapter, we will cover the following recipes:

  • Using dollar expansion in Set Analysis to enable from-date and to-date selection
  • Using alternate states with Set Analysis
  • Using Set operators to exclude values from results
  • Using Set Analysis with a Date Island
  • Using Sets to avoid key tables

Introduction

I was lucky enough to attend the 2008 QlikView Global Partner Conference, Qonnections, in the Loews Hotel, Miami Beach.

There were several significant things that happened at that event, including a key note speech from Stephen Few and Capricorn Ventis winning a partner award.

From a technical point of view, the most significant thing that happened was during the CTO's report—Jonas Nachmanson announced the forthcoming Set Analysis ...

Get QlikView for Developers Cookbook 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.