Databases Reference
In-Depth Information
The tabs in the
Movie Database
document also follow a logical order. An
introduction is shown on the
Intro
tab, followed by a demonstration of the key
concept of QlikView on the
How QlikView works
tab. After the contrast with
Traditional OLAP
is shown, the associative
QlikView Model
is introduced. The
last two tabs show how this can be leveraged by showing a concrete
Dashboard
and
Analysis
:
Slicing and dicing your data
As we saw when we learned about the associative user experience, any selections
made in QlikView are automatically applied to the entire data model. As we will see in
the next section, slicing and dicing your data really is as easy as clicking and viewing!
List-boxes
But where should we click? QlikView lets us select data in a number of ways.
A common method is to select a value from a list-box. This is done by clicking
in the list-box.
Let's switch to the
How QlikView works
tab to see how this works. We can do this
by either clicking on the
How QlikView works
tab on the top of the sheet, or by
clicking on the
Get Started
button.
The selected tab shows two list boxes, one containing
Fruits
and the other containing
Colors
. When we select
Apple
in the
Fruits
list-box, the screen automatically updates
to show the associated data in the
Colors
list-box:
Green
and
Red
. The color
Yellow
is shown with a gray background to indicate that it is not associated, as seen below,
since there are no yellow apples. To select multiple values, all we need to do is hold
down
Ctrl
while we are making our selection.