Databases Reference
In-Depth Information
For more examples, head to the
Help
menu in QlikView,
select
Contents
, and activate the
Index
tab from the left
pane to search for
Set Analysis
. There is also a document
on QlikCommunity that explores additional examples:
http://community.qlikview.com/docs/DOC-1867
The possibilities are endless. Take a moment to try it out in the Airline Operations
document and see for yourself what you can do with Set Analysis. In the solution
file corresponding to this chapter, we've included an additional sheet, named Set
Analysis, with different examples of Set Analysis uses.
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 through October 2010 versus January through October 2009
• October 2010 versus October 2009
• October 2010 versus September 2010
At the same time, all user selections across the different Airline, Aircraft, or Airport
attributes must be taken into consideration in all point-in-time analyses.
Let's work some Set Analysis magic.
