Qlik Sense Set Analysis Practice: What Does It Return?

Unlimited Qlik Sense set analysis practice. Each problem shows a small table, the current selections and one set expression: pick the result, or tap the rows it adds up. A wrong answer names the slip, such as reading 1 as $.

Current selections

All the data is one flat table, so a row is in the current selection when it matches every chip.

Tap the rows in the table.Rows selected: 0

Answer to see the working.

Qlik Sense exam prep

Preparing for a Qlik Sense certification? Start with the free real exam questions, then get the full pack.

Qlik QSBA202450 real exam questions · US$39
Free: 11 questionsGet the full pack
Qlik QSDA202478 real exam questions · US$39
Free: 7 questionsGet the full pack

Set analysis FAQ

What is the difference between $ and 1 in Qlik set analysis?

$ is the current selection, and 1 is every record in the app, whatever is selected. So Sum({$} Sales) changes when you select something, and Sum({1} Sales) does not.

Is Sum({$} Sales) the same as Sum(Sales)?

Yes. The Qlik help says the set expression {$} is the same as not stating a set expression. A modifier with no identifier, such as Sum({<Year={2025}>} Sales), also works on $.

Does a set modifier add to the current selection?

No. Year={2025} defines a new selection in Year and replaces the old one, so a selected 2024 no longer counts. Selections in the other fields still apply, because $ keeps them.

What does Field= with nothing after the equals sign do?

It clears the selection in that field only. Sum({$<Region=>} Sales) returns the sales for the current selection with the Region selection removed, and every other selection stays.

What is the difference between Year={2025} and Year+={2025}?

Year={2025} replaces the Year selection with 2025. Year+={2025} is an implicit union: it adds 2025 to the years already selected, the same as Year=Year+{2025}.

What does -= do in a set modifier?

It removes values from the selection in that field. If the value is not part of the selection, the Qlik help says the set expression will not change any numbers.

What does a set expression return when no record matches?

An empty set, and Sum() over an empty set shows 0. Qlik gives this example: Country*={Canada} when Canada is not selected.

When do values in a set modifier need quotes?

When they contain blanks or special characters. Single quotes are a literal, case sensitive match. Double quotes are case insensitive and are also used for searches.

What does this drill leave out?

Searches, the P() and E() functions, dollar sign expansion, bookmarks, alternate states and data models with several tables. Each problem uses one flat table, so every selection applies to the same rows.

Sources
  • Qlik Sense on Windows help, November 2026: Set analysis and Set identifiers: a selection defines the set of records a sum uses; 1 is every record, $ is the current selection and {$} equals no set expression; with no identifier, $ is assumed; Field= removes the selection in that field.
  • Set modifiers and Syntax for set expressions: a modifier names fields and the selection to make in each; values in curly brackets separated by commas; quotes for blanks or special characters.
  • Set modifiers using assignments with implicit set operators and Set modifiers with set operators: Field={..} replaces the selection in the field; += and -= are an implicit union and exclusion; an empty set shows 0.
  • Tutorial: Creating a set expression: two modifiers together intersect, and 1 ignores the current selection.
  • Checked 20 November 2026. The tool's own approach: the tables are invented and each problem uses one flat table, where a row is in the selection when it matches every chip, and every selected value still has a row under the other selections. Qlik's example tables on these pages are reproduced exactly in the tool's tests, and an independent re-solver agreed with the drill on 20,000 generated problems.

Checked 20 November 2026 against the Qlik Sense on Windows help (November 2026 release) on set analysis.

More free tools

All free tools