QlikView QSBA2018 Exam
Qlik Sense Business Analyst Certification Exam - June 2018 Release (Page 3 )

Updated On: 1-Feb-2026

A data architect adds a field to an existing data model that contains new values for the ProductGroup. The business analyst needs to efficiently update the app and meet these requirements:
- Use the existing charts, which are built using a master item dimension called ProductGroup
- Existing charts must use the new values for ProductGroup
- Business users must be able to compare the new and old values

How should the business analyst meet these requirements?

  1. Change the ProductGroup dimension using the new field, and create a new dimension in the master items for the old field
  2. Create a calculated dimension on the charts to allow the users to compare the new value to the old value
  3. Replace the dimensions on all charts to use the new ProductGroup field added to the data model
  4. Use set analysis on the chart measures to see the difference in ProductGroup between the new field and the old field

Answer(s): D



A business analyst creates a scatter plot and wants to save it for reuse by colleagues. The business analyst must remain the owner of this scatter plot and should be the only person allowed to make changes. These changes should be applied automatically to all instances of this visualization Which two actions should the business analyst take to meet these requirements? (Select two.)

  1. Copy the scatter plot on every sheet of the app
  2. Add the finished scatter plot to the master items
  3. Copy the scatter plot to the custom objects
  4. Publish the app to the Everyone stream
  5. Publish the finished scatter plot to the hub

Answer(s): C,E



A printing company has several requirements for a new Qlik Sense app
- Report of daily work orders
- Total number of print jobs
- Print jobs based on region
- Total number of print jobs by month

The app will be used by executives, sales managers, sales representatives, and press workers.
Which sheets should a business analyst build to meet these requirements?


  1. - Sheet 1: Details page that shows the daily print jobs in a table
    - Sheet 2 Dashboard with a KPI visualization of total print jobs, and a bar chart with print jobs by region
    - Sheet 3: Visualizations that show the count of print jobs by month and press worker

  2. - Sheet 1: Details page that shows the daily print jobs in a table
    - Sheet 2: Dashboard with a KPI visualization of total print jobs by month, customer sales representative, and region
    - Sheet 3 Report page that shows the daily print jobs

  3. - Sheet 1 Dashboard with a KPI visualization of total print jobs, and a bar chart with print jobs by region
    - Sheet 2: Visualizations that show the count of print jobs by month, customer sales representative, and region
    - Sheet 3: Details page that shows the daily print jobs in a table

  4. - Sheet 1: Dashboard with a KPI visualization of total print jobs, and a bar chart with print jobs by region
    - Sheet 2 Details page that shows the daily print jobs in a table
    - Sheet 3: Report page that shows the daily print jobs

Answer(s): C



A business analyst must create a horizontal bar chart to identify the top Sales Reps. Customer Segment Description, and Customer City
- Users must be able t(^analyze the data for one field at a time
- The chart should show the unique number of customers for each dimension being analyzed
- The dimensions and measures created must be re-used on other charts Which steps should the business analyst perform to configure the chart correctly?


  1. - Create all three dimensions as master items and add one as the chart dimension and the other two as alternative dimensions
    - Create a master item measure using Count(Distinct [Customer Number]) and add it to the chart
    - Change the chart presentation to Horizontal and sort it by the measure

  2. - Create a cyclic dimension as a master item using all three dimensions and add it to the chart
    - Create a master item measure using Count{Distinct [Customer Number]) and add it to the chart
    - Change the chart presentation to Horizontal and sort it by the measure

  3. - Create all three dimensions as master items and add one as the chart dimension and the other two as alternative dimensions
    - Create a master item measure using Count(Total (Customer Number)) and add it to the chart
    - Change the chart presentation to Horizontal and sort it by the measure

  4. - Create all three dimensions as master items and add to the bar chart
    - Create a master item measure using Count{Distinct [Customer Number]) and add it to the chart
    - Change the chart presentation to Horizontal and sort it by the first dimension

Answer(s): A



A wholesaler needs to show sales and products in a PowerPoint presentation. The dimensions and measures are:
- Product Name

- Sum of Sales
- Number of Orders
Which two chart types could the business analyst use to meet these requirements? (Select two.)

  1. Stacked bar chart
  2. Combo chart
  3. Scatter plot
  4. Distribution plot
  5. Treemap

Answer(s): A,B



Viewing page 3 of 11
Viewing questions 11 - 15 out of 50 questions



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

Join the QSBA2018 Discussion