Databases Reference
In-Depth Information
Let's look at an example of the second use case. On the
Reports
tab, we created a
pivot table that shows passengers and departures by airline and period. Let's see
how we can use a calculation condition to only calculate the chart when less than 25
airlines are selected:
1.
Right-click on the
Passengers/departures per Airline/Period
pivot table and
select
Properties
.
2.
Select the
General
tab.
3.
In the
Calculation Condition
input box enter the following expression:
Count(Distinct [Carrier Name]) <= 25
4.
Click on the
Error Messages
button.
5.
In the
Custom Error Messages
dialog, select
Calculation condition
unfulfilled
from the list of
Standard Messages
.
6.
In the
Custom Message
input box, enter
Please select fewer than 25
carriers for this pivot table to be calculated
.
7.
Click on
OK
to close the
Customer Error Messages
dialog.
8.
Click on
OK
to close the
Chart Properties
window.
If you have more than 25 carriers selected, instead of the pivot table, you will now
see a blank square with the error message that we entered. Selecting 25 carriers or
less automatically recalculates and displays the pivot table.
By now, you have seen much of what QlikView has to offer in additional interactivity.