A business analyst must display current year sales versus previous year sales by region, sub-region, and city.
The result will be a pivot table, with rows for the region, sub-region, and city, and columns for Current Year Sales and Previous Year Sales.
Which calculated expressions should the business analyst create to meet these requirements?
A.
B.
C.
D.
The correct calculated expressions to display current year sales versus previous year sales in a pivot table with rows for region, sub-region, and city, and columns for Current Year Sales and Previous Year Sales, should dynamically reference the current year and previous year based on the system date. Therefore, the correct expressions would be: Sum({$<OrderYear = {$(=Year(Today()))}>} Sales) and Sum({$<OrderYear = {$(=Year(Today())-1)}>} Sales). This ensures that the expressions correctly reference the current year and the previous year dynamically. The '$(=Year(Today()))' portion dynamically calculates the current year, and '$(=Year(Today())-1)' calculates the previous year.
D Sum({$<OrderYear = {$(=Year(Today()))}>} Sales) Sum({$<OrderYear = {$(=Year(Today()-1))}>} Sales)
NOT A ) As 'CurrentYear' is not calculating anything NOT B ) As the functions will not work as there is no '$' sign expansions for the expressions NOT C) Because TODAY(0) is incorrect D) Correct
D, debes coger el valor del resultado de la function year y eso se hace con $()
on Qlik site: The correct answer is: Sum({$<OrderYear = {$(=Year(Today()))}>} Sales)
"Yes, I also answered this question on the Qlik site, and it's quite confusing that they only allow responses for the current year when they are also asking for comparisons to the last year. Without the data from the last year, it's challenging to make meaningful comparisons. :)"
D is correct