Free QlikView QSBA2022 Exam Questions

Become QlikView Certified with updated QSBA2022 exam questions and correct answers

Page: 1 / 24

Total 120 Questions | Updated On: Oct 29, 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 : the Data Viewer, add a calculated field named "Sales" with the expression: UnPrice * Qty

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

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

D : 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 : single configurator

B : ange chart properties

C : velop a widget

D : eate 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

The board asked the team to review current sales by age group on a bar chart. These groups were created in Data Manager and named AgeGroup, as follows:
• Children: up to 16 years;
• YoungAdult: between 17 and 30 years old;
• Adult: 31+
The analyst then defines the colors of the bars with an expression:
If( AgeGroup = 'Children', Red(), If( AgeGroup = 'YoungAdult', Blue(), Green() ))
What's left to complete the jobs and apply the result to the visualization?

A : object properties, in data, create a calculated dimension using the informed expression

B : eate a master item for the dimension. In object properties, in color, select Color by Dimension and use the master item created

C : the object properties, in appearance, select Colors and then select the Color by Expression type. Be sure to keep selected the option "the expression is a color code"

D : eate a metric as a master item with this expression. In the view select Color by Metric and point to the master item created

Answer: C

Question 5

A company uses a Dashboard for its analysis. Users noticed some needs and created multiple bookmarks to optimize daily work. A developer had previously created some help markers based on interviews conducted with business users during the development stage. The company decided to take advantage of the bookmarks created by users and add to existing bookmarks.
What steps should the business analyst take to meet the requirements?

A : • Create a duplicate copy of the app• Delete the published app• Publish the duplicate app

B : • Prompt the developer and/or user to publish the bookmark to the community

C : • Duplicate the app in Work• Review previous bookmarks• Replace the existing published app

D : • Review previous bookmarks• Copy the app to a new stream• Publish the app in the new stream

Answer: B

Page: 1 / 24

Total 120 Questions | Updated On: Oct 29, 2025

Add To Cart