Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Qlik QV12BA - QlikView 12 Business Analyst Certification Exam

Qlik QV12BA Premium Access     Download Demo    
Page: 1 / 2
Total 50 questions

A data architect needs to develop a dashboard to represent the previous year's sales performance in a simple KPI object Which expression should be used to calculate this value?

A.

Sum({}Sales)

B.

Sum({}Sales)

C.

Sum(Aggr(Sum(Sales),Max(Year)-1))

D.

Sum(Aggr

Refer to the exhibits.

Table_1 has been transformed into Table_2. Which action did the business analyst take to transform the table?

A.

In the Dimension Limits tab, checked Show Total

B.

In the Presentation tab. checked Subtotals at Top

C.

In the Presentation tab. checked Show Partial Sums

D.

In the Presentation tab checked Totals on Last Row

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 )

A.

List box

B.

Input box

C.

Muiti box

D.

Table box

E.

Statistics box

Refer to the exhibit.

Which is the highest performing expression to accurately count the number of Account Owners?

A.

COUNT (%AccountOwnerId)

B.

COUNT(AccountOwnerld)

C.

COUNT(DISTINCT %AccountOwnerId)

D.

COUNT(TOTAL %AccountOwnerId)

A business analyst needs to analyze average sales by product number and country by year. Which measure(s) should the business analyst use?

A.

Year

B.

Average Sales

C.

Average Sales and Year

D.

Product Number and Average Sales

A business analyst wants to display several dimensions and key performance indicators (KPI) in one object Aggregations must be done in this object. The user must be able to change the sorting of the dimensions and KPIs quickly and easily.

Which object meets these requirements?

A.

Pivot table without automatic pivoting

B.

Bar chart with groups of dimension and expression

C.

Table box without drop-down selection

D.

Straight table with interactive sorting

Refer to the exhibit.

A business analyst creates a straight table to display net sales and commissions. The table uses the Anal font by default. The analyst will use a Text Format Expression to show commissions greater than $200 in Arial Bold font.

Which is the correct expression?

A.

=If(Conroission > 200, *')

B.

=If(Conroission > 200, 'Bold1)

C.

=If(Conroission > 200, 'Arial Bold')

D.

=If (Coitinission > 200, * Commissior.' )

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 )

A.

Add five dimensions *

B.

Add five measures

C.

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

D.

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

E.

Use the Bar Offset property with the correct expression

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?

A.

View > Resize Window > 1280 x 800

B.

View > Fit Zoom to Window > 1280 x 800

C.

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

D.

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

Refer to the exhibit.

The dataset shown has been loaded into a QhkView application The user has selected the year 7015' to analyze

This expression is used to calculate a value:

Num((Sum({!<[Month] = {'May'} >> SalesAmt-COGS)/Sum({1<[Month] = {'May*} >} SalesAmt)), â– #,##0.0**)

What is the result?

What is the result?

A.

13 5%

B.

22.5%

C.

34.8%

D.

77.5%