QlikView Business Analyst QV12BA Exam Practice Questions

The QlikView Business Analyst certification is for all roles involved in the analysis, design and layout of the QlikView application user interface. You can choose to pass the QV12BA QlikView 12 Business Analyst Certification Exam. It measures your knowledge of interface design of QlikView applications. For the complete and comprehensive QlikView QV12BA exam preparation you can trust the valid QV12BA exam questions. Below are QV12BA free demos available.

Page 1 of 2

1. Which two objects are created with ONLY measures? (Select two.)

A)





B)





C)





D)





E)

Exhibit A

Exhibit B

Exhibit C

Exhibit D

Exhibit E

 Loading...

2. Refer to the exhibit.





A business analyst creates a water fall chart to understand how an initial value is affected by a series of intermediate positive and negative values.

Which two actions must a business analyst perform to create the water fall chart shown? (Select two)

Add five dimensions *

Add five measures

Check "Show as water fall" on the Style tab of the bar chart properties

On the dimension limit properties sheet set limit to only show the first five values .

Use the Bar Offset property with the correct expression

 Loading...

3. What are two ways to calculate the Sales for the ProductCategory. Shoes? {Select two)

Money(Sum(<ProductCategory={ ' Shoes * }>SaIes))

Money(Sum({<ProductCategory={'Shoes*}>}Sales))

Money(Sum(<?roductCategory={Shoes}>Sales))

Money(Sum({<{ProductCategory > = 'Shoes'>}Sales))

Money(Sum({<?roductCategory={Shoes}>}Sales))

 Loading...

4. A customer needs to measure sales by assigned sales representative.

All previous and current sales representative assignments must be included so that sales representatives receive credit for sales activities on both previous and current sales.

Which type of dimension is described by the sales representative assigned to the client?

Composite dimension

Slowly changing dimension

Historical lookup dimension

Interval matching dimension

 Loading...

5. An Invoices table has a DaysOverdue field A chart is required to analyze overdue invoices in 30 day intervals.

Which function should a business analyst use to meet this requirement?

Aggr (DaysOverdue,30)

Class(DaysOverdue, 30)

GroupBy(DaysOverdue,30)

IntervalMatch(DaysOverdue,30)

 Loading...

6. A business analyst needs to create a dashboard showing only numerical values. There is NO need to filter data or select any

dimensions.

Which three objects can the business analyst use? (Select three)

Bar chart

Grid chart

Gauge chart

Scatter chart

Straight table

 Loading...

7. Refer to the exhibits.





Chart_1 has been transformed into Chart_2

Which action did the business analyst take to transform the chart?

In the Dimensions tab. set '<S2>' as the Line Style of the dimension

In the Style tab. selected Dashed Line from the Style drop-down menu

In the Expressions tab. set '<S2>' as the Line Style of the expression

In the Expressions tab. selected Dashed Line from the Style drop-down menu

 Loading...

8. Refer to the exhibit.





The Product Sales table shown represents the entire data set. A business analyst adds an expression in a document.





Next, the analyst selects Product Category = 'Bikes' and Product Subcategory = 'Road Bikes'.

What is the result of the expression with these selections'?

0

910.000

40.000.000

85 000 000

 Loading...

9. A business analyst designs a sheet with a list of customers. The analyst wants to add a small image to show the company logo for each customer.

Which three objects meet this requirement? (Select three)

List box

Input box

Muiti box

Table box

Statistics box

 Loading...

10. A business analyst has data for these fields

• Year

• Sales Amount

• Product Number

• Country

• Order Number

How many dimensions and measures exist?

One dimension and four measures

Two dimensions and three measures

Three dimensions and two measures

Four dimensions and one measure

 Loading...

Page 2 of 2

11. A business analyst creates a document with two sheets, Sheetl and Sheet2 The analyst needs to add a button on Sheetl. which will open Sheet2 and lock atl fields.

How should the analyst create this trigger?

In Document Properties, add the Lock All action to the OnOpen trigger

In Sheet Properties of Sheet1 add the Lock Field action to the OnLeaveSheet trigger

In Button Properties, add the Activate Sheet action for Sheet2 and the Lock All action

In Button Properties, add the Activate Sheet action for Sheet2 and the Lock Field action

 Loading...

12. A business analyst needs to visualize the sales of products by product category, product sub-category, and product name. The analyst would like to see the relative sales by product hierarchy without using a drill-down dimension.

Which chart type should the analyst use?

Grid chart

Block chart

Combo chart

Radar chart

 Loading...

13. Refer to the exhibits.





A business analyst has an application showing sales performance. The analyst will enter an expression in the search box of a filter pane to show only Salesman who generate more than $200,000 in sales.

Which is the correct expression?

=Sum(Sales) >200000

=If(Sum(Sales)>200000, Salesman)

=Firstname(Salesman=,Rob,, 'Tom', 'Helen', 'Rock', 'Leif')

= If (WildMatch (Salesman, 'Rob*' , "Tom"', 'Helen* ', 'Rock*' , 'Leif"') , Sales)

 Loading...

14. Refer to the exhibit.





A data architect loads the three data sources without adjusting the load script.

What is the result?

A data model with three tables and a synthetic key

A data model with three tables with a circular reference

A data model with two tables that load without warnings or errors

A data model with three tables that load without warnings or errors

 Loading...

15. A customer specified that the QlikView application should be designed to fit a screen resolution of 1280 x 800 as a standard.

Which option will assist a business analyst while creating the user interface?

View > Resize Window > 1280 x 800

View > Fit Zoom to Window > 1280 x 800

Settings > User Preferences > Design Tab and select 1280 x 800

Settings > User Preferences > Design Tab and select Display Grid Lines

 Loading...

 Loading...