These labs are based on Garcia, M., Harmsen, B. (2012). QlikView 11
for Developers
Open the file you submitted on Wed for Lab 4 graded lab
In this lab you will work with real publicly available data.
The original data files have been downloaded from The Bureau of
Transportation
Statistics of the United States website (http://transtats.bts.gov), and
have been
pre-processed.
Create a new Sheet; Dashboard. Add the following List Boxes:
Year, Quarter, Month, Carrier's
Operating
Region, Carrier Group, Aircraft Group, and Flight Type.
Modify the List Box for Year to display all 3 years in one row
Modify the List Box for Month, to display a table of 2 rows and 6
columns
Modify the List Box for for Quarter to display a table of 2 rows and 2
columns
Modiy the BAR Chart to Create a Cyclic Expression Group. Add the following
Expressions:
Sum ([# Transported Passengers]). Set the label for this
expression
as # of Enplaned Passengers.
Sum ([# Transported Freight]). Set the label for this expression
as
Transported Freight.
Sum ([# Transported Mail]). Set the label for this expression
as
Transported Mail.
Format ALL expressions as Integers
Find the busiest month/year for each category (expression).
Clone this chart and convert it to Line Chart
Make the following modifications: Clear Sort Option
Add TrendLine AVERAGE for each expression
Analyze the Chart
Add Expression into List Box:
Carrier Name List Box expression: sum([#
Departures Performed]).
Change the name of the List Box to: Carrier Name
(#Departures)
Create a Multi Box
Title: Flight Information.
Choose the following Fields: From - To City,
Origin City, Origin Country, Destination City, Destination Country, and
Distance Interval.
On the Sort tab, Distance Interval,
in the Sort by section, uncheck the Text option, and mark the Load
Order checkbox.
Find Destination Cities and Countries, Origin Cities and Countries
and Carrier Names that fly Distance Interval 9500-9999
Create the Current Selestions Box
Wait for Demonstration of the Features
Create a Bookmark Object
Wait for Demonstration of the Features
Create a New Sheet: AdvancedBarChart
Create a bar Chart to display number of passengers
and number of available seats by flight type.
Title: #passengers/#available seats by flight type
Dimension: Flight Type
Expressions: Sum ([# Transported Passengers]), Sum([# Available
Seats]). Label them: [# Transported Passengers and # Available
Seats
For each Expression: Select Values on Data Points checkbox
On Axes Tab: Select Show Grid for BOTH Axes
On Numbers Tab: Select Fixed to 1 Decimals, and Million for Million
Symbol
Analyze the Chart
Create Pie Chart to display Market Share.
Dimension: Carrier Name,
Expression: Sum([# Transported Passengers]). Select Relative and
Show Values on Data Points. Click
finish. The chart
looks too crowded.
Open chart properties and go to the Dimension Limits
tab.
Mark the Restrict which values are displayed using the first
expression
checkbox.
Select the Show only values that accumulate to radio button and set
the corresponding value to 50% relative to the total. Enable the Include
Boundary Values checkbox as well.