Online Access Free QV12BA Practice Test

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>')
• B.=If (Coitinission > 200, * <B>Commissior.</B>' )
• C.=If(Conroission > 200, 'Bold1)
• D.=If(Conroission > 200, 'Arial Bold')

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 > Fit Zoom to Window > 1280 x 800
• B.Settings > User Preferences > Design Tab and select 1280 x 800
• C.Settings > User Preferences > Design Tab and select Display Grid Lines
• D.View > Resize Window > 1280 x 800

Which is the most appropriate object to display a picture and launch an external task?

• A.Extension object
• B.Image object
• C.Container object
• D.Text object

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'?

• A.€ 40.000.000
• B.€910.000
• C.€0
• D.€85 000 000

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(Aggr<Sum(Sales),Max(Year-l)))
• B.Sum(Aggr(Sum(Sales),Max(Year)-1))
• C.Sum({<Year={Max(Year)-!}>}Sales)
• D.Sum({<Year={$(=Max(Year)-I)}>}Sales)