Free QSBA2018 Exam Braindumps (page: 6)

Page 5 of 13





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 this error?

  1. Change the OrderDate number formatting to 'Date' in the properties panel
  2. Create a new calculated field for OrderDate with: Date (Floor (OrderDateTime))
  3. Change the OrderDate field type to "Date" with the format 'YYYY-MM-DD' in the data manager
  4. Create a new calculated field for OrderDate with: Date (LTrim (OrderDateTime, 10))

Answer(s): C



A business analyst is NOT familiar with the data and is using insight advisor to create a number of visualizations.
Which steps should the business analyst take to add the visualizations to a sheet?

  1. Click Generate insights to find visualizations, then click Add to sheet
  2. Use the selection tool to find visualizations, then click Add to sheet
  3. Use smart search to find visualizations, then click Add to sheet
  4. Drag and drop fields on the workspace, then click Add to sheet

Answer(s): A





Refer to the exhibit.
A business analyst is testing an existing app that returns unexpected results. Using the selection tool, the business analyst observes the following behavior
- Select a CompanyName and the associated OrderlD records are white
- Select a Year and all OrderlD records are gray
- Select an OrderlD and the Quarter values are all gray, but the CompanyNames are white
- Select a ProductID and the associated ShipperName and OrderDates are white, but the Year is gray What is causing these results?

  1. OrderlD should be the key field in the MasterCalendar
  2. The logical model is NOT a star schema
  3. The OrderDate fields are different data types
  4. MasterCalendar should be associated to the OrderDetails table

Answer(s): C



A company has customers in 16 countries. The majority of the customers are in Germany A business analyst creates a fitter pane for Country and wants "Germany" listed first. The rest of the countries should be listed in alphabetical order.
Which method should the business analyst use to meet this requirement?

  1. Edit the sheet, select Chart Properties panel Custom sorting, then select Germany
  2. Edit the sheet, select Chart Properties panel Custom sorting, then click Descending Frequency
  3. In the data manager edit the table, select Country! then select Order from the data profiling card
  4. In the data manager, edit the table, select Country, then select Order from the column header

Answer(s): D






Post your Comments and Discuss QlikView QSBA2018 exam with other Community members:

QSBA2018 Discussions & Posts