Databases Reference
In-Depth Information
To display these metrics, we will be using
Text Objects
. A text object can be used to
display a static or calculated text and, somewhat counter-intuitively, images as well.
Let's follow these steps to create the first text object that will display Enplaned
Passengers:
1.
Right-click anywhere on an empty space in the worksheet and select
New
Sheet Object
|
Text Object
.
2.
In the
Text
input box enter the following expression:
=Num(Sum ([# Transported Passengers]) / 1000000, '#,##0.00')
3.
Move the
Transparency
slider, at the bottom of the window, to
100%
.
4.
Go to the
Font
tab and set the
Font
option
to
Tahoma
,
Font Style
to
Bold
,
and
Size
to
16
.
5.
On the
Layout
tab, enable the
Use Borders
checkbox.
6.
On the
Caption
tab, check the
Show Caption
checkbox and define the
Title
Text
field as
Transported passengers (millions)
.
7.
Set the
Horizontal Caption Alignment
option to
Centered
.
8.
Mark the
Wrap Text
checkbox under
Multiline Caption
.
9.
Click on
OK
to close the dialog window.
After some resizing, the resulting object should look like the following screenshot.
Looking at the steps we went through to create this text object, you may have noticed
a few things:
• The expression we used was prefixed with an
=
(equal to) sign. This is
to tell QlikView to treat the entered text as an expression and evaluate it
accordingly, instead of treating it as a static text.
• The
Text
object does not have the
Number properties
tab which is often seen
on other objects, that is why we used the
Num()
function to properly format
the expression output.
• By checking the
Wrap Text
option we can create a multiline caption, this can
be very useful when we have long caption texts and limited horizontal space.