Free Practice QlikView QSBA2022 Exam Questions 2025

Stay ahead with 100% Free Qlik Sense Business Analyst QSBA2022 Dumps Practice Questions

Page: 1 / 24

Total 120 Questions | Updated On: Apr 21, 2025

Add To Cart

Question 1

A business analyst needs to analyze sales using an existing Sales Orders application:

• The sales order details table were added from a QVD file using Data Manager;

• The in-app and QVD sales order table does not have the pre-calculated "Sales" field

• Sales can be calculated by multiplying between "Qty" and "UnPrice"

How should the business analyst add the "Sales" field to the sales order table?

2021-10-22-14-30-44-24d6ee1c04d0d9442c628f3ab0500d6a

A : In the Data Viewer, add a calculated field named "Sales" with the expression: UnPrice * Qty

B : In Data Manager, add a calculated field named "Sales" with the expression: Sum(UnPrice * Qty)

C : In Data Manager, add a calculated field named "Sales" with the expression: UnPrice * Qty

D : In qvd file sales orders, add an additional field with the name "Sales" with the expression: UnPrice * Qty

Answer: C

Question 2

A sales department has a pie chart that displays the total amount os sales by city.
Users have requested several changes to the pie chart:
• Display the labels in 'Red';
• Increase the font size of the title;
• Change the color of the values to 'Blue'.
Which technique should a business analyst use to meet these requirements?

A : Use single configurator

B : Change chart properties

C : Develop a widget

D : Create a custom theme

Answer: D

Question 3

A business analyst must display current year sales versus previous year sales by region, sub-region and city.
The result will be a pivot table, with rows for the region, sub-region, and city, and columns for Current Year Sales and Previous Year Sales.
Which calculated expressions should the business analyst create to meet these requirements?

A : 1. Sum({$< OrderYear = {$(=Year(Today()))} >} Sales)2. Sum({$< OrderYear = {$(=Year(Today())-1)} >} Sales)

B : 1. Sum({$< OrderYear = {CurrentYear} >} Sales)2. Sum({$< OrderYear = {CurrentYear-1} >} Sales)

C : 1. Sum({$< OrderYear = {Year(Today())} >} Sales)2. Sum({$< OrderYear = {Year(Today())-1} >} Sales)

D : 1. Sum({$< OrderYear = {$(=Year(Today(0)))} >} Sales)2. Sum({$< OrderYear = {$(=Year(Today(0))-1)} >} Sales)

Answer: A

Question 4

A business analyst using a shared folder mapped to S \419379942\ receives an Excel We with more than 100 columns Many of the columns are duplicates. The current set of columns mat should be used have the suffix '_c* appended to the column name

What should the business analyst do to load the Excel data?

A : Open the Excel file, remove all columns that do not have the suffix '_c' and save t>e Me to be loaded

B : Deselect the fields that do NOT have the '_c' suffix in the data manager table preview

C : Utilize drier functionality in the data manager to select only columns with the suffix _C with a fitter condition

D : Load all columns because the recommended associations will use only columns with the suffix '_c*

Answer: C

Question 5

A cinema company is analyzing the age group of customers who watch movies at least once a month and where they live. The following requirements should be considered:

• Age of customers

• Customer address

• Frequency of visits

What objects should the business analyst use to meet the requirements?

A : A distribution chart and a pie chart

B : A map and scatter plot

C : A map and histogram

D : A distribution chart and a treemap

Answer: C

Page: 1 / 24

Total 120 Questions | Updated On: Apr 21, 2025

Add To Cart