QV12BA QlikView 12 Business Analyst Certification Exam Questions and Answers

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?

A business analyst needs to calculate the average order value by country. Which two objects meet this requirement? (Select two.)

Refer to the exhibit.

The straight table does NOT show all rows from the Field1 list box What does this indicate about the dataset?

A business analyst wants to display sales by country region, city and customers. All the dimensions needs to be shown. Which chart can display a hierarchy without a drill-down dimension?

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 )

How many dimensions and measures are required to create a scatter chart?

A business analyst will compare sales growth between this year and last year by country. The analyst is given the sales values and must calculate the growth.

Which two charts can be used? (Select two.)

A business analyst has data for these fields

• Year

• Sales Amount

• Product Number

• Country

• Order Number

How many dimensions and measures exist?

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 business analyst has data for these fields

• Year

• Sales Amount

• Product Number

• Country

• Order Number

Which three KPIs may be calculated? (Select three.)

Refer to the exhibit.

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

Next, the analyst selects Year = ' 2010 ' and RegionID = ' 2\. What is the result of the expression with these selections?

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