Seeing is Believing - QlikView 11 for Developers - page 37

There is another rule for constructing data models: Two
tables should be linked by only one field. If they have two
or more fields in common, a Synthetic Key will be created
which can be a potential issue that needs to be addressed.
We'll cover these rules in depth in Chapter 4 , Data Modeling .
Creating the dashboard tab
In this section, we will see how we can enhance the analytical capabilities of our
QlikView document by adding interactive charts.
First, we will add a new sheet and name it Dashboard . From the design toolbar,
locate the Add Sheet button, shown below, and click on it.
To rename the new sheet, right-click on its background area and select Properties… .
Then, from the Sheet Properties window, activate the General tab, locate the Title
field, and type Dashboard . Click on OK .
If the design toolbar is not visible, go to
View | Toolbars | Design on the menu bar.
Creating and positioning the filters and user controls
We will start by adding user controls in the form of listboxes to our new sheet.
Right-click on a blank space of the sheet area and click on Select Fields… . Then, add
the following fields to allow filtering: Year , Quarter , Month , Carrier's Operating
Region , Carrier Group , Aircraft Group , and Flight Type .
After adding the specified fields, click on OK .
We will adjust some of the properties in the created listboxes, starting with the Year
listbox. Right-click on it and select Properties… from the context menu.