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 in QlikView 8.5. When Jonas was done, all of the techies in the room gave a standing ovation. It was pretty incredible.

Prior to version 8.5, if I wanted to calculate the sales for the current year, I had to do something like this:

Sum(If(Year=vMaxYear, Sales, 0))

If the user then clicked on a different year, the values changed.

Now, I can write it as follows:

Sum({<Year={$(=Max({1} Year))}>} Sales)

The syntax is a little arcane, but easy once you become experienced with it.

If the user changes the selection, it doesn't matter, because the year is going...