This time, I’m sharing with you a “QlikView Set Analysis Cheat Sheet”. A resource that I hope you can use as reference when struggling with set analysis expressions and as a quick guide to discovering the full power of set analysis.
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.