QV12BA

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)View AnswerAnswer: B

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 . 0 B....

A business analyst has data for these fields • Year • Sales Amount • Product Number • Country • Order Number How many dimensions and measures exist?A . One dimension and four measures B. Two dimensions and three measures C. Three dimensions and two measures D. Four dimensions and one...

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?A . In Document Properties, add the Lock All action to the OnOpen trigger B....

What are two ways to calculate the Sales for the ProductCategory. Shoes? {Select two)A . Money(Sum(<ProductCategory={ ' Shoes * }>SaIes)) B. Money(Sum({<ProductCategory={'Shoes*}>}Sales)) C. Money(Sum(<?roductCategory={Shoes}>Sales)) D. Money(Sum({<{ProductCategory > = 'Shoes'>}Sales)) E. Money(Sum({<?roductCategory={Shoes}>}Sales))View AnswerAnswer: D,E

Which two objects are created with ONLY measures? (Select two.) A) B) C) D) E) A . Exhibit A B. Exhibit B C. Exhibit C D. Exhibit D E. Exhibit EView AnswerAnswer: C,D

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...

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?A . Grid chart B. Block chart C. Combo...

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...

Refer to the exhibit. A data architect loads the three data sources without adjusting the load script. What is the result?A . A data model with three tables and a synthetic key B. A data model with three tables with a circular reference C. A data model with two tables...