Qlik Exam QSDA2024 Topic 5 Question 5 Discussion

To meet the requirements of displaying the current year's total sales in a way that responds to user selections, the correct approach involves using both SET and LET statements to define the necessary variables in the data load editor.

Explanation of Option C:

SET vCurrentYear = Year(Today());

The SET statement is used here to assign the current year to the variable vCurrentYear. The SET statement treats the variable as a text string without evaluation. This is appropriate for a variable that will be used as part of an expression, ensuring the correct year is dynamically set based on the current date.

LET vCurrentYTDSales = '=SUM({$<Year={'$(vCurrentYear)'}>} [Sales Amount])';

The LET statement is used here to assign an evaluated expression to the variable vCurrentYTDSales. This expression calculates the Year-to-Date (YTD) sales for the current year by filtering the Year field to match vCurrentYear. The LET statement ensures that the expression inside the variable is evaluated, meaning that when vCurrentYTDSales is called in a chart or KPI, it dynamically calculates the YTD sales based on the current year and any user selections.

Key Points:

Dynamic Year Calculation: Year(Today()) dynamically calculates the current year every time the script runs.

Responsive to Selections: The set analysis syntax {$<Year={'$(vCurrentYear)'}>} ensures that the sales totals respond to user selections while still focusing on the current year's data.

Appropriate Use of SET and LET: The combination of SET for storing the year and LET for storing the evaluated sum expression ensures that the variables are used effectively in the application.