QlikWorld 2020 Global Conference. Join us to discover how to get the most from your data. Act fast. Register now and save.

Selections in charts and tables

The selection procedure in charts and tables has been designed to be as intuitive as possible. In most cases you will find it possible to make selections directly in the chart plot area by clicking individual values (bars etc.) or by “painting” over a larger selection.

If you find that you cannot make selections in a chart as indicated, the chart may be in Detached mode or Read Only mode.

Chart Properties

Selections in Bar, Line, Combo, Radar, Grid and Scatter charts

Selections can be made inside the plot area by clicking on a single data point or painting over several data points. When painting, a green raster indicates the selection until the mouse button is released. The selection will be made for the dimension values used for calculating the selected data point(s).

Selections can be made by clicking or painting in the chart legend (except when the legend is indicating chart expressions rather than dimension values).

Selections can be made by clicking or painting over the dimension axes and its labels (except scatter charts). The corresponding field values will be selected.

Selections can be made by painting over the expression axes and its labels. The field values which generate data points in the indicated result area will be selected.

Note: Selections made directly in line charts and bar charts (not combo charts) showing more than one dimension will primarily apply to just one dimension. Selections In line charts primarily apply to the second dimension so that painting over a line selects the entire line over all x-axis dimension values. In bar charts the opposite applies, i.e. selections primarily apply to the first dimension.

Selections in Pie charts

Selections can be made inside the plot area by clicking on a single pie slice or painting over several slices. When painting, a green raster indicates the selection until the mouse button is released. The selection will be made for the dimension values used for calculating the selected data point(s).

Selections can be made by clicking or painting in the chart legend.

Selections in Block charts

Selections can be made inside the plot area by clicking a single block or by painting over several blocks. When clicking, selections are made with drill-down functionality so that the first click selects a single value in the 1st dimension. Clicking a second time (i.e. within the selection) selects a single value in the 2nd dimension and so on.

When painting, a green raster indicates the selection until the mouse button is released. The selection will be made for the dimension values used for calculating the selected data point(s). By painting across the boundaries of several values of the 1st dimension, all sub-values of the 2nd and 3rd dimensions belonging to these values are selected, not just the ones touched by the selection.

Selections in Gauge charts

Selections cannot be made in gauge charts.

Selections in Straight tables

Selections can be made in the dimension columns by clicking on a cell or painting over several cells. The selected area is marked green until the mouse button is released.

Selections can be made in the expression columns by clicking in a single cell. The selection will be made for the dimension values used for calculating the selected expression cell.

Selections in Pivot tables

Selections can be made in the dimension columns/rows by clicking on a single cell. The selected cell is marked green until the mouse button is released.

Selections can be made in the expression columns/rows by clicking in a single cell. The selection will be made for the dimension values used for calculating the selected expression cell.

Selections in Table boxes

Selections can be made by clicking in any cell or by painting over an area covering one or more rows and one or more columns. The selected area is marked green until the mouse button is released.

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?