Selections in Other Objects

You can make selections directly in fields in most objects. In tables, the color of the cell becomes green to mark its value as selected. Click to select a value or paint with the mouse to select multiple values.

You can also make selections by searching.

The following section describes how you can make selections in the different types of objects. If you find that you cannot make selections in an object as described below, the chart may be in Detached mode or Read Only mode.

Statistics Boxes

In statistics boxes you can click on some of the statistical quantities such as Min, Max and Median, and the corresponding value will be selected. The selection is not marked in the statistics box but only in other boxes.

Multi Boxes

A row in the Multi Box represents a field. Clicking on the small arrow displays a list of values that belong to the field. You can make selections and searches in this list just as in a list box.

Table Boxes

You can make selections in table boxes by clicking in any cell or by painting over an area covering one or more rows and one or more columns. If the option Drop-down Select is active, an arrow is displayed in the column heading. Clicking on the arrow displays a list of the values that belong to this field. You can make selections and searches in this list just as in a list box.

Slider/Calendar Objects

In sliders, where a single field is the basis,you can select a value by adjusting the thumb tack to the desired position. If the slider is accordingly configured, the size of the thumb tack can be changed with a mouse click. This way it is possible to select several values.

Clicking on the small calendar symbol in a calendar object opens the calendar. You can select a date or a period of time with the mouse depending on the configuration of the calendar object, and this selection is transferred to the underlying field. Using Ctrl+Click you can select several periods even if they are in different months or years.

Bar, Line, Combo, Radar, Grid and Scatter Charts

In these objects, you can make selections in different ways:

  • By clicking on a single data point or painting over several data points inside the plot area. When painting, the area covered is shown with a green raster. The selection will be made for the dimension values used to calculate the selected data point(s).
  • By clicking or painting in the chart legend (except when the legend is indicating chart expressions rather than dimension values).
  • By clicking or painting over the dimension axes and its labels (except scatter charts). The corresponding field values will be selected.
  • By painting over the expression axes and its labels. The field values which generate data points in the indicated result area will be selected.

When painting selections in line charts and bar charts with more than one dimension the behavior of the QlikView selection logic differs slightly from that of other charts in order to better reflect the expectations of the user. Selections in these types of charts do not affect both dimensions at the same time.

In line charts selections will be primarily done in the second dimension. This means that painting over a line will select the entire line over all x-axis dimension values.

In bar charts the opposite applies. Selections primarily apply to the first dimension. This means e.g. that clicking one bar segment will result in a selection of that segment’s x-axis dimension value but leave all stack or cluster segments possible. When selections have narrowed down the primary selection dimension to one single value, the old selection logic will apply again, making selections prevail also in the secondary selection dimension.

In combo charts selections always affect all dimensions.

Pie Charts

You can make selections inside the plot area by clicking on a single pie slice or painting over several slices. When painting, the area covered is shown with a green raster. The selection will be made for the dimension values used to calculate the selected data point(s).

You can also make selections by clicking or painting in the chart legend.

Block Charts

You can select individual blocks in block charts. The drilldown functionality is used to refer to a certain dimension - selecting the first block refers to the first dimension, selecting a second block within the first refers to the second dimension etc.

You can also select several blocks by painting an area. This selected area is marked green until you release the mouse button. Such a selection refers back to the value or values of the first dimension. Based on these values the corresponding blocks are calculated. If a selection crosses the block borders of several values that belong to the first dimension, it will affect all related values belonging to the second and third dimensions as well, not only those in the selected area.

Gauge charts

Selections cannot be made in gauge charts since there is no dimension defined.

Straight Tables

You can make selections in the dimension columns of a straight table by clicking on a cell or painting over several cells. The selected area is marked green until you release the mouse button.

If Drop-down Select is activated in a column that represents a dimension, a small arrow will be displayed in the column header. Clicking on the arrow will display a list of all values of the field. You can make selections and searches in this list.

You can also make selections in the expression columns by clicking in a single cell. The selection will be made for the dimension values used to calculate the selected expression cell.

Pivot Tables

You can make selections in a pivot table in the dimension columns/rows by clicking on a single cell. The selected cell is marked green until you release the mouse button.

If Drop-down Select is activated in a column that represents a dimension, a small arrow will be displayed in the column header. Clicking on the arrow will display a list of all values of the field. You can make selections and searches in this list.

You can also make selections in the expression columns/rows by clicking in a single cell. The selection will be made for the dimension values used to calculate the selected expression cell.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?