Databases Reference
In-Depth Information
One thing you may notice is that while we entered three expressions, only two are
visible in the chart. This happens because we did not select any display mode for
the
Load Factor
expression. However, we did activate the
Values on Data Points
checkbox, and that is why the value for
Load Factor
is shown in the chart.
You may also wonder about the expression that we used to calculate the
Load
Factor
value:
Column(1) / Column(2)
This expression tells QlikView to divide the result of the first expression by the result
of the second expression. You will understand that the order of the expressions
should not be changed in order for this to work reliably.
Container
By now, with three charts already created, our worksheet is becoming somewhat
cluttered again. Time to do another round of reorganizing. The option of choice this
time will be a container object in which we will group multiple objects together in the
same screen space. The user will then be able to interactively switch between objects.
Let's put all three charts (or, two charts and a table) into the container object by
following these steps:
1.
Go to
Layout
|
New Sheet Object
|
Container
in the menu bar.
2.
On the
General
tab, select the three items corresponding to our charts
from the
Existing Objects
list (
Traffic per Year
,
Top 10 Routes
, and
#
of Passengers
).
In the
Existing Objects
list, objects are prefixed with their
Object ID
, for example,
CH03 Traffic per Year
.
3.
Click on
Add
to place them in the
Objects Displayed in Container
list to the
right.
4.
Go to the
Presentation
tab and select
Tabs at bottom
from the
Appearance
drop-down menu.
5.
Go to the
Layout
tab and deactivate the
Use Borders
option.
6.
Click
OK
to close the
Container Properties
dialog and create the new object.