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

Qlik QV12BA - QlikView 12 Business Analyst Certification Exam

Page: 2 / 2
Total 50 questions

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?

A.

Aggr (DaysOverdue,30)

B.

Class(DaysOverdue, 30)

C.

GroupBy(DaysOverdue,30)

D.

IntervalMatch(DaysOverdue,30)

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.

250

B.

750

C.

850

D.

650

A business analyst has data for these fields

• Year

• Sales Amount

• Product Number

• Country

• Order Number

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

A.

Average Sales Per Year

B.

Total Sales by Country

C.

Total Sales by Customer

D.

Average Order Sales Amount

E.

Total Customer Count by Country

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.

Composite dimension

B.

Slowly changing dimension

C.

Historical lookup dimension

D.

Interval matching dimension

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?

A.

=Sum(Sales) >200000

B.

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

C.

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

D.

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