Databases Reference
In-Depth Information
From the list on the left, locate and highlight the
Year
field and add it to the
Used
Dimensions
list by clicking on the
Add >
button. After that, click on
Next
, as shown
in the following screenshot:
We will now deal with the expression, which is the formula QlikView will use
to calculate the metric we want. In this case, we want to get the total (a sum
aggregation) number of flights performed. In the
Edit Expression
dialog, which
opens automatically after clicking on
Next
in the previous window, type:
Sum ([# Departures Performed])