Qlik Sense Business Analyst Certification Exam - 2022 - QSBA2022

Refer to the exhibit.

A CEO wants to use a similar visualization on the company's dashboards
The visualization must meet several requirements
Show three years of sales data
Display sales trends by month
Allow comparison of years using an area style display
Which set of actions should a business analyst take to meet these requirements?

• A. Add an area chart
  Add Year first then Month as the dimensions
  Add Sum(Sales) as the measure
  In the properties panel under Area select the dimensions
• B. Add a fine chart
  Add Month first then Year as the dimensions
  Add Surry Sales > as the measure
  In the properties panel under Presentation select Area
• C. Add a ,line chart
  Add a master drill-down dimension with Year and Month
  Add Sum(Sates) as the measure
  In the properties panel under Presentation, select Area
• D. Add an area chart
  Add Month first then Year as the dimensions
  Add SumfSates) as the measure
  In the properties panel under Area select the dimension Year

A company CFO has requested an app that contains visualizations applicable to analyzing the finance data Each regional finance team will analyze their data, and the app must contain a high-level sheet that navigates to relevant detail sheets.
Which features support a logical design structure?

• A. A dashboard of KPIs and section access
• B. A dashboard with regional bookmarks
• C. A Multi KPI set analysis
• D. A pivot table that filters by region

A business analyst is creating a new app with sales data.
The visualizations must meet several requirements:
A Bar chart mat shows sales by product group is used m multiple sheets
A KPI object that visualizes that the total amount of sales is used once
A Treemap mat shows margin by product group is used one time inside a Container What should be added to the master items library?

• A. Bar chart
• B. Treemap
• C. KPI
• D. Container

A business analyst is developing an app that contains a data model with fields Country. City. Sales ProductName and ProductCategory. The global sales manager wants to add new visualizations to this app The business analyst must include the following Ability to dynamically change the number of countries and cities Display a maximum of 10 countries Display a maximum of 5 cities per country Which steps should the business analyst take?

• A. 1 Add an input field for vCountry and vCity
  2 Sat the dimension limitation to the required maximum values 5 and 10
  3 Apply the variable to each visualization
  4 Add a bookmark Country and City
• B. 1Add an input field for vCountry and vCity
  2 Set the dimension limitation to the required maximum values 5 and 10
  3 Apply the variable to each visualization
• C. 1 Create two variables vCountry and vCrty
  2 Add a slider for vCountry and vCity
  3 Apply the variable to each virtualization
  4 Set a sheet action that limits the data displayed
• D. 1 Create two variables vCountry and vCity
  2 Add a slider for vCountry and vCity
  3 Apply the vanable to each virtualization

A customer wants to perform a regional sates analysis to learn how products setover time m different areas. The business analyst needs to design a sheet in the app tor business users to perform several tasks
Select two different groups of countries to study
Compare sales over time between these two groups using a bar chart
Change the group items by selecting different countries at any time
Select a time range in the bar chart and drill-down to daily transactional sales.
What steps should the business anaryst follow to meet these requirements?

• A. Create one Alternate State Set1
  Create two Filter Panels one associated to this Set1and one Default State(S)
  Create a Bar chart with the drill-down dimension and two measuressum({Set1'$} Sales)and sum({'Set1"S) Sales)
• B. Create one Alternate State Set1
  Create two Filter Panels one associated lo this Set1 and one Default State1($)
  Create a Bar chart with the drill-down dimension and two measures sum({Set1-$) Sales) and sum('Set1-S) Sales)
• C. Create two Alternate States Sell and Set2
  Create two Finer Panels each associated with an Alternate Stale
  Create a Bar chart with drill-down dimension and two measures sum({Set1'S} Sates) and sum({,Set2'*S} Sales)
• D. Create two Alternate States Set1and Set2
  Create two Filter Panels each associated with an Alternate State
  Create a Bar chart with a drill-down dimension and two measures sum({Set1'$} Sales) and sum{fSet2"S} Sales)