As you know already, I'm a big fan of using Set Analysis in my QlikView applications, especially for Point In Time Reporting. However, there might be some specific situations in which Set Analysis just won't cut it and you need an alternative... Continue Reading to discover it! (Demo Script included...)
Today we continue with 'The Magic of Set Analysis' Series and, in this post I will share with you a "goodie". Something that has helped me speed up the Development process on new projects, and is specially useful when creating SiB's (Seeing Is Believing) or Prototypes for prospective clients, where the time is often short.
I have always believed that Set Analysis' Raison d'être is to satisfy a basic need in any BI Tool: the ability to perform "Point In Time" Analysis. But, needless to say, it is also amazingly useful for the fulfillment of a bunch of other special needs. In this post, I will cover the specifics of Point In Time Reporting with Set Analysis.
In Part II of The Series, I wrote about the general syntax of a Set Expression and provided some basic examples using Set Modifiers with explicit field value definitions. Now, our next step will be about making our desired record set dynamic and based on the user's current selections, that is, using an Implicit field value definition.
In this new Post of The Series, I will go over the details for creating a correct Set Expressions. Also, I will provide some useful examples for you to get your Hands On right away.
This is the First Part of a Series called 'The Magic of Set Analysis' which is intended to serve as a guide for those newcomers to the subject that want to take full control of their chart expressions.