Point In Time Reporting
One of the most common use cases of Set Analysis is Point In Time Reporting. Having the ability to perform period-over-period analysis is a basic requirement in any BI tool and is easily performed in QlikView with the aid of set expressions. However, needless to say, Set Analysis is also amazingly useful for the fulfillment of other special requirements.
Let's combine the acquired knowledge and apply it to add Point In Time Reporting to our Airline Operations document.
The challenge
HighCloud Airlines' executives require a dashboard to easily compare different performance indicators in a period-over-period basis. The different period comparisons they need are:
- Current Year-To-Date indicators versus the same period last year
- Current month versus same month last year
- Current month versus previous month
The comparisons should be dynamic and based on the user's selections. So, if the user selects October 2010, the corresponding comparisons should be:
- From January...
