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
Qlik Sense exam prep
Preparing for a Qlik Sense certification? Start with the free real exam questions, then get 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.
- DrillOracle SQL NULL practicePredict what a query returns with NULLs in NOT IN, COUNT, NVL and ORDER BY, plus set operators.
- DrillTableau order of operations practiceTap filters and calculations in the order Tableau runs them, or work out what a small view shows with a context filter, FIXED, top N or table calculation.
- BuilderCron expression builderBuild a 5-field crontab schedule, read it in plain English and see the next 5 run times.