Databases Reference
In-Depth Information
Dimension Limits
As the goal of this chart is to display who the big players on the market are, we will
modify the chart so that it will only show the airlines that make up 50 percent of the
market. All other airlines will be grouped in an
Others
group.
Follow these steps:
1.
Right-click on the pie chart and select
Properties…
.
2.
Go to the
Dimension Limits
tab.
3.
Mark the
Restrict which values are displayed using the first expression
checkbox.
4.
Select the
Show only values that accumulate to
radio button and set
the corresponding value to
50% relative to the total
. Enable the
Include
Boundary Values
checkbox as well.
5.
Click on
OK
to close the properties dialog.
The updated pie chart should look like the following screenshot:
We now see that there are actually only five airlines that, put together, account
for 50 percent of transported passengers. Also note that the amounts are shown
as a percentage, even though the expression we used returns an absolute number
(amount of passengers transported). This is because we have set the
Relative
checkbox on the
Expressions
tab, which makes QlikView automatically calculate the
relative amount versus the total amount for each slice.
The
Dimension Limits
option we have used to achieve this is a very useful feature
that was introduced in QlikView 11 and enables us to control the number of
dimension values handled by a chart.