Free Preparation Discussions
MENU
Qlik QSDA2024 Exam - Topic 5 Question 5 Discussion
Topic #: 5
Sales managers need to see an overview of historical performance and highlight the current year's metrics. The app has the following requirements:
* Display the current year's total sales
* Total sales displayed must respond to the user's selections
Which variables should a data architect create to meet these requirements?
A)
B)
C)
D)
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.
Vince
3 months agoAngelyn
3 months agoIsabelle
3 months agoAlease
4 months agoDerick
4 months agoShenika
4 months agoCelia
4 months agoKasandra
4 months agoRebbecca
5 months agoNatalya
5 months agoAlida
5 months agoMaia
5 months agoRana
5 months agoEladia
5 months agoReynalda
1 year agoGalen
1 year agoJosefa
1 year agoMerilyn
1 year agoCoral
1 year agoAshton
1 year agoCecilia
1 year agoMariko
1 year agoAudry
1 year agoClement
1 year agoViki
1 year agoNina
1 year agoViki
1 year agoNina
1 year agoViki
1 year agoRessie
1 year agoFrederica
1 year agoFrederica
1 year ago