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 with the selections Year, Product Group and Region made. Region is locked.

Selections bar with three selections, one is locked.

Note: When 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 pop-up 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 Region with selection pop-up menu.

Selection pop-up menu.

Selection 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.

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?