QSBA2024 practice question 3 of 10
The VP of Sales asks a business analyst to include a KPI object on the sales dashboard that shows total sales value for the year 2022, regardless of selections. Existing fields in the data model include Sales and Year. How should the business analyst write the measure for the KPI object?
Full set: 50 questionsThe requirement is to calculate a value "regardless of selections." In Qlik's Set Analysis syntax, the identifier 1 is used to represent the entire set of records in the data model, thereby ignoring any selections made by the user. The expression Sum({1} Sales) correctly calculates the sum of the Sales field over all records in the application. While the full expression to meet the request would also need a modifier for the year (), this option correctly uses the identifier required to ignore selections.
A. Sum( { } Sales) This is syntactically incorrect. A set expression requires an identifier (like 1 or $) within the curly braces {} to define the record set to be evaluated.
B. Sum( { $ } Sales) The $ identifier represents the current user selections. This expression is equivalent to Sum(Sales) and would change as the user makes selections, which is the opposite of the requirement.
D. Sum( 1 { } Sales) This is syntactically incorrect. The set identifier 1 must be placed inside the curly braces, not outside of them. ---
1. Qlik Sense for Developers - Second Edition (2021), by Miguel Ángel García and Barry Harmsen. Chapter 6: Set Analysis, Section: "Set identifiers". The book explains: "The number 1 as a set identifier represents the full set of records in the application, ignoring any selections." (This is a conceptual reference as direct page numbers for digital editions vary, but the concept is fundamental in the Set Analysis chapter).
2. Qlik Sense Official Help Documentation, "Set analysis and set expressions". In the section "Set identifiers," the documentation explicitly states:
1: "Represents the full set of all the records in the application, irrespective of any selections made."
$: "Represents the records of the current selection. The expression sum(Sales) is equivalent to sum({$} Sales)."
This directly supports that 1 is used to ignore selections and $ respects them.
3. Qlik Sense Official Help Documentation, "Syntax for set expressions". This section outlines the correct structure of a set expression as { identifier { operator modifier } }, confirming that identifiers like 1 and $ must be placed within the curly braces, rendering options A and D syntactically invalid.
Keep practicing
Take the free QSBA2024 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other QSBA2024 practice questions
- Question 1A business analyst needs to create a visualization that compares two measures over time u…
- Question 2A business analyst is creating a new app with sales dat a. The visualizations must meet s…
- Question 4A project management team uses an app to monitor different projects. • Projects may have …
- Question 5A business analyst receives an image of a dashboard from the HR Director and is asked to …
- Question 6Two customers in an organization want to use an app that contains a finance data set. Wit…
- Question 8A business analyst created a visualization that has a color indicator when an order is be…
