QSBA2018 Exam QuestionsBrowse all questions from this exam

QSBA2018 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?

Show Answer
Correct Answer: B,D

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

2 comments
Sign in to comment
elipsaOption: D
Apr 23, 2023

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

[Removed]Option: B
Sep 4, 2023

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