Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is here asking only for one solution?
Hello everyone,
I recently encountered a business analysis question that has left me quite puzzled, and I would like to seek your insights and opinions on the matter.
The question asked for a calculated expression to display "current year sales versus previous year sales" in a table. However, the phrasing of the question seems to be open to interpretation, which has led to my confusion.
here is the quiz and answer:
The provided standard answer is:
Sum({$<OrderYear = {$(=Year(Today()))}>} Sales)
My proposed alternative answer is:
Sum({$<OrderYear = {$(=Year(Today())-1)}>} Sales)
This expression calculates the sum of sales for the current year, which I think is also relevant for the comparison.
as I was only allowed to choice one answer. but in the questions it asked plural.
Should the question be interpreted to focus solely on the previous year's sales, or is it reasonable to include the current year's sales for a comprehensive year-over-year analysis? what do you think? It is just so confusing.
You don't need to be confused. Question and the proposed correct answer aren't suitable to each other. AFAIK it happens by the majority of quiz quite regardless to the kind of examination - it's not Qlik related.