Databases Reference
In-Depth Information
Undoing selections
Fortunately, if we end up making a wrong selection, QlikView is very forgiving.
Using the
Clear
,
Back
, and
Forward
buttons in the toolbar, we can easily clear the
entire selection, go back to what we had in our previous selections, or go forward
again. Just like in our Internet browser, the
Back
button in QlikView can take
us back multiple steps:
Changing the view
Besides filtering data, QlikView also lets us change the information being displayed.
We'll see how this is done in the following sections.
Cyclic Groups
Cyclic Groups
are defined by developers as a list of dimensions that can be
switched between users. On the frontend, they are indicated with a circular arrow.
For an example of how this works, let's look at the
Ratio to Total
chart, seen in the
following image. By default, this chart shows movies grouped by duration. If we
click on the little downward arrow next to the circular arrow, we will see a list of
alternative groupings. Click on
Decade
to switch to the view to movies grouped
by decade.
Drill down Groups
Drill down Groups
are defined by the developer as a hierarchical list of dimensions
which allows users to drill down to more detailed levels of the data. For example, a
very common drill down path is Year | Quarter | Month | Day. On the frontend,
drill down groups are indicated with an upward arrow.