Question 10
Refer to the exhibits.
A business analyst must create a bar chart to show the total value of orders processed per day. The dataset loaded by the data architect only contains the OrderNo, OrderDateTime, and OrderAmount.
The business analyst creates a calculated field, OrderDate, using the expression, Date(OrderDateTime). The bar chart does NOT present the information correctly.
How should the business analyst fix the error?
Change the OrderDate number formatting to ‘Date’ in the properties panel
Create a new calculated field for OrderDate with: Date(Floor(OrderDateTime))
Change the OrderDate field type to ‘Date’ in the format ‘YYYY-MM-DD’ in the data manager.
Create a new calculated field for OrderDate with: Date(LTrim(OrderDateTime,10))
Correct answer: C
Explanation:
Reference: https://1c-predpriyatie-qlik.ivan-shamaev.ru/wp-content/uploads/2018/01/Manage_data_Qlik_Sense.pdf
Reference: https://1c-predpriyatie-qlik.ivan-shamaev.ru/wp-content/uploads/2018/01/Manage_data_Qlik_Sense.pdf