How should the business analyst fix the error?

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?
A . Change the OrderDate number formatting to ‘Date’ in the properties panel
B . Create a new calculated field for OrderDate with: Date (Floor (OrderDateTime))
C . Change the OrderDate field type to Date’ in the format ‘YYYY-MM-DD’ in the data manager.
D . Create a new calculated field for OrderDate with: Date (LTrim (OrderDateTime,10))

Answer: C

Explanation:

Reference: https://1c-predpriyatie-qlik.ivan-shamaev.ru/wp-content/uploads/2018/01/ Manage_data_Qlik_Sense.pdf