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 listbox. This is done by clicking in the listbox.

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 listboxes, one containing Fruits and the other containing Colors. When we select Apple in the Fruits listbox, the screen automatically updates to show the associated data in the Colors listbox: Green and Red. The color Yellow is shown with a gray background to indicate that it is not associated, as seen in the following screenshot, since there are no yellow apples. To select multiple values, all we need to do is hold down Ctrl key while we are making our selection, as shown in the following screenshot:

Besides selections in listboxes, we can also directly select data in charts. Let's jump to the Dashboard tab and see how this is done. The Dashboard tab contains a chart labeled Number of Movies, which lists the number of movies by a particular actor. If we wish to select only the top three actors, we can simply drag the pointer to select them in the chart, instead of selecting them from a listbox, as shown in the following screenshot:

Because the selection automatically cascades to the rest of the model, this also results in the Actor listbox being updated to reflect the new selection, as shown in the following screenshot:

Of course, if we want to select only a single value in a chart, we don't necessarily need to lasso it. Instead, we can just click on the data point to select it. For example, clicking on James Stewart leads to only that actor being selected.

While listboxes and lassoing are both very convenient ways of selecting data, sometimes we may not want to scroll down a big list looking for a value that may or may not be there. This is where the search option comes in handy.

For example, we may want to run a search for the actor Al Pacino. To do this, we first activate the corresponding listbox by clicking on it. Next, we simply start typing and the listbox will automatically be updated to show all values that match the search string. When we've found the actor we're looking for, Al Pacino in this case, we can click on that value to select it, or simply hit Enter, as shown in the following screenshot:

Sometimes, we may want to select data based on associated values. For example, we may want to select all of the actors that starred in the movie The Godfather. While we could just use the Title listbox, there is also another option: associated search.

To use associated search, we click on the chevron on the right-hand side of the search box. This expands the search box and any search term we enter will not only be checked against the Actor listbox, but also against the contents of the entire data model. When we type in The Godfather, the search box will show that there is a movie with that title, as seen in the following screenshot. If we select that movie and click on Return, all actors that star in the movie will be selected, as shown in the following screenshot:

To create a new bookmark, we need to open the Add Bookmark dialog. This is done by either pressing Ctrl + B or by selecting Bookmarks | Add Bookmark... from the menu.

In the Add Bookmark dialog, seen in the following screenshot, we can add a descriptive name for the bookmark. Other options allow us to change how the selection is applied (as either a new selection or on top of the existing selection) and if the view should switch to the sheet that was open at the time of creating the bookmark. The Info Text allows for a longer description to be entered that can be shown in a pop-up when the bookmark is selected.

We can retrieve a bookmark by selecting it from the Bookmarks menu, seen here:

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, as shown in the following screenshot:

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 screenshot. 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 are defined by the developer as a hierarchical list of dimensions that 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.

In the Movies Database document, a drill down can be found on the tab labeled Traditional OLAP. Let's go there.

This drill down follows the path Director > Title > Actor. Click on the A. Edward Sutherland to drill down to all movies that he directed, shown in the following screenshot. Next, click on Every Day's A Holiday to see which actors starred in that movie. When drilling down, we can always go back to the previous level by clicking on the upward arrow, located at the top of the listbox in this example.

Containers are used to alternate between the display of different objects in the same screen space. We can select the individual objects by selecting the corresponding tab within the container. Our Movies Database example includes a container on the Analysis sheet.

The container contains two objects, a chart showing Average length of Movies over time and a table showing the Movie List, shown in the following screenshot. The table is shown by default and you can switch to the Average length of Movies over time by clicking on the corresponding tab at the top of the object.