Free QlikView QSBA2022 Exam Questions

Become QlikView Certified with updated QSBA2022 exam questions and correct answers

Page: 1 / 24

Total 120 Questions | Updated On: Feb 09, 2026

Add To Cart

Question 1

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 2

A business analyst is creating an app that requires several visualizations

* A scatter plot mat shows the margin percentage and total sales by product category

* A map with a the layer that visualizes lines between retail stores and lactones

* A KPI that shows total cost

Margin?n be calculated by dividing profit by revenue Profit is the difference between total cost and total sates

Which two sets of fields can the business analyst use to meet these requirements? (Select two.)

A : Line GeometryMargin%

B : Product CategoryLocation

C : SalesTotal Cost

D : Product CategoryRetail Store LocationFactory Location

E : ne Geometry

Answer: A,C

Question 3

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

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 : en the Excel file, remove all columns that do not have the suffix '_c' and save t>e Me to be loaded

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

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

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

Answer: C

Question 5

A business analyst has access to all of a company's data tor the past 10 years The source table consists of the following fields Transactions Transaction Time Transaction Date Transaction Year Cardholder Cardholder address Cardissuer and Amount Users request to create an app based on this source

Users only review me data for the past 2 years Data must be updated daily Users do not view cardholder into

What should the business analyst do to reprove the app performance?

A : 1. Deselect Cardholder and time field in data manager2. Use a pant based on auto-calendar fields3. Perform a daily reload via the data manager

B : 1. Delete Cardholder and time fields in data manager2. Use set analysis to show data based on transaction year3. Use an API to perform a daily reload task

C : 1. Deselect Cardholder and time fields in data manager2. Apply a filter to extract data based on transaction year3. Request a daily reload task from the System Admin

D : 1. Delete Cardholder and time fields in data manager2. Use a bookmark based on auto-calendar fields3. Use the reload function in the sheet Editor asset panel

Answer: D

Page: 1 / 24

Total 120 Questions | Updated On: Feb 09, 2026

Add To Cart