Exam QSBA2018 All QuestionsBrowse all questions from this exam
Question 16

Refer to the exhibit.

A business analyst creates a bar chart and notices the weekdays are NOT in a US default format. The analyst does NOT have permissions to enter the data load editor and edit the data. The analyst only has a few minutes before the meeting to show the insights to a manager.

The business analyst wants to quickly customize the chart to show the weekdays in US format.

Which action should the business analyst take to fix the chart?

    Correct Answer: B

    To format the weekdays in the desired US format without accessing the data load editor, the business analyst should change the dimension to a calculated dimension that allows specifying the correct weekday format directly in the chart. This approach is appropriate because it enables the analyst to manipulate the display of the dimension without altering the underlying data. The DATE() function or REPLACE() function would not be suitable here as they either require access to the data load editor or are not intended for this purpose.

Discussion
[Removed]Option: B

Correct answer: B Proof from Qlik Sense official website: calculated dimension also applicable on charts (not only data loader) https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/Dimensions/calculated-dimensions.htm D is wrong: replace is used in data loader to change text fields, not format dates. See: https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions/Replace.htm

elipsaOption: D

D. Change the dimension to a calculated dimension using the REPLACE() function.