# QlikView Business Analyst (QV12BA) Certification Exam Sample Questions

Welcome! Preparing for the QlikView Business Analyst (QV12BA) certification exam can be a daunting task, but we're here to make it easier for you. Here are the sample questions that will help you become familiar with the Qlik QV12BA exam style and structure. We encourage you to try our Demo QlikView Business Analyst Certification Practice Exam to measure your understanding of the exam structure in an environment that simulates the actual test environment.

### Why Use Our QlikView Business Analyst Sample Questions?

To make your preparation easier for the Qlik QV12BA exam, we strongly recommend you to use our Premium QlikView Business Analyst Certification Practice Exam. According to our survey with certified candidates, you can easily score more than 85% in your actual QlikView Business Analyst exam if you score 100% in our premium certification practice exams.

## Qlik QV12BA Sample Questions:

01. A business analyst has two identical QlikView documents, Document_A and Document_B.
The analyst would like to create a button object in Document_A, which when clicked, will open Document_B with the same selections as Document_A. On the Actions tab, the analyst adds the action, Open QlikView Document, and selects Document_B.
What other selection should the business analyst make to achieve this behavior?
a) Check Transfer State
b) Add the action, Dynamic Update
c) Add the action, Copy State Contents
d) Check Apply state on top of current

02. An application contains a chart with the expression:
Sum(Qty*Amount - Qty*DiscountAmount)
What should a business analyst modify to optimize the chart?
a) The load script to: Qty* (Amount - DiscountAmount) as LineItemTotal and modify the expression to LineItemTotal
b) The expression to: Sum (Qty* (Amount - DiscountAmount) )
c) The load script to: Qty* (Amount - DiscountAmount) as LineItemTotal and modify the expression to Sum(LineItemTotal)
d) The expression to: Sum (Qty*Amount) - Sum (Qty*DiscountAmount)

03. A business analyst needs a KPI to show sales of all years since year 2000. Assume the current year is 2017. Which expression should the business analyst use?
a) Sum( { \$<Year={2000+}>} Sales)
b) Sum( { \$<Year={ ">2000"}>} Sales )
c) Sum( { \$<Year={ "2" }>} Sales)
d) Sum( { \$<Year={2000-2017}>} Sales)

04. A business analyst creates a document that shows data from various countries. The users want to select one or more different countries to complete their analysis.
Which three objects meet these requirements?
(Select three.)
a) Table box
b) Statistics box
c) Text box
d) Slider
e) List box

05. A business analyst needs to analyze sales using a hierarchical dimension of region, country, and city. Which chart should be used?
a) Pie chart
b) Block chart
c) Combo chart
d) Scatter chart

06. A business user needs to analyze different KPIs such as sales amount, price, and discount by product group. Which chart type should be used?
a) Block chart
b) Pie chart
c) Line chart
d) Scatter chart

07. A business user opens a QlikView application on an iPad, and scroll bars are displayed on the right side of the screen. What should the business analyst do to remove the scroll bars?
a) Select View > Fit Zoom to iPad
b) Apply the correct Theme for the iPad
c) Rotate the iPad from landscape to portrait view
d) Redesign the application with consideration of the tool bar and tab row

08. A business analyst creates a document with two sheets. The analyst needs to create a trigger to perform an action when the document opens in QlikView Desktop.
Where should the analyst add the trigger?
a) In Document Properties, under Sheet Event Triggers
b) In Sheet Properties, under Sheet Event Triggers
c) In Document Properties, under Document Event Triggers
d) In Sheet Properties, under Document Event Triggers

09. A business analyst wants to get a better understanding of the relationship between revenue, margin dollars, and growth percentage for each product they sell.
Which object should the business analyst use?
a) Bar chart
b) Pie chart
c) Combo chart
d) Scatter chart

10. A business analyst needs to create a KPI dashboard with three gauges to measure the performance of a sales organization.
Which three measures are the most appropriate for a business analyst to use?
(Select three.)
a) Total Cost by Product
b) Margin Month over Month
c) Sales Year over Year
d) Cost Year to Date
e) Total Sales by Region