Skip to main content Skip to complementary content

Exploring with selections

During analysis, your selections are displayed above the sheet.

Each selection item has a small bar at the bottom that reflects the selection states for that dimension. Three states are displayed in the bars: selected (green), alternative (light gray), and excluded (dark gray). Locked values are indicated by a lock icon.

Selections bar
Information noteWhen an app is saved using Qlik Sense, the current selections and locks are not saved. Selections and locks must be made every time the app is opened.

When you click a selection item, a popup appears. This lets you view, edit, or clear that selection. You can also search for dimension values or lock the selection. In the following image the selection menu is open. Some options may not be available, depending on what selections were made previously,

Selection menu in the selection popup

The following table describes the options.

Select all All values are selected (marked m). Alternative values change state to selected (green). Excluded values change state to selected excluded. They are still dark gray, but are now selected (marked m). If you clear the selections that made these values excluded, they will change state to selected (green).
Select possible All possible values (white) are selected. This option is never available in the selections item, because when a selection is made, the other values are either alternative or excluded. In a filter pane, however, you can have possible values as a result of another selection.
Select alternative

When a selection has already been made in a field, alternative values, when present, have a light gray color. These are values that would have been possible values (white), if a selection had not already been made in that field.

By selecting alternative values, the values that previously were selected become alternative.

Select excluded

If there are alternative values, they will be selected (green) and the values that previously were selected will change state to alternative. Excluded values will change state to excluded.

If there are no alternative values, the excluded values are selected (green), and the previously selected values change state to alternative.

Export data

Export the selected data to an Excel file.

See: Exporting data from a visualization

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!