How should the business analyst write the measure for the KPI object?

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?

A. Sum ({ < year="|" ‘2022,="" }="" /> } Sales)

B. Sum ({ $ < year="{" ‘2022*="" )="" /> } Sales)

C. Sum ({ 1 < year="{" ‘2022’="" )="M /> ) Sales)

D. Sum (1 { < year="(" ‘2022’="" )="" /> ) Sales)

View Answer

Answer: C

Explanation:

In this scenario, the VP of Sales wants to see the total sales for the year 2022 regardless of selections. This requirement is best handled using Set Analysis in Qlik Sense. The key to achieving this is using the set identifier 1, which ignores the user’s selections and ensures the calculation is based on the entire dataset. The expression Sum( { 1 < year = { ‘2022’ } > } Sales) calculates the sum of sales for the year 2022, irrespective of any other selections made in the app.

Key Concepts:

Set Identifier 1: This identifier ensures that the calculation is performed on the entire dataset, ignoring any selections or filters applied by the user.

Year Filtering: The expression < year = { ‘2022’ } > ensures that only sales from the year 2022 are included in the calculation.

Why the Other Options Are Less Suitable:

A. Sum( { < year = ‘2022’ > } Sales): This is incorrectly formatted, and the pipe (|) symbol should not be used in this context.

B. Sum( { $ < year = { ‘2022’ } > } Sales): The $ set identifier respects the current selections, which is not what is needed in this case, as the VP wants the value to be shown regardless of selections.

D. Sum( 1 { < year = { ‘2022’ } > } Sales): The placement of 1 is incorrect in this expression.

References for Qlik Sense Business Analyst:

Set Analysis: Qlik Sense’s Set Analysis allows analysts to control what data is used in a calculation, regardless of user selections. The set identifier 1 ensures that selections are ignored, which is essential for showing fixed data such as total sales for a specific year.

Thus, the correct expression to show the total sales for 2022, regardless of user selections, is C.