- All Exams Instant Download
Which function should a business analyst use to meet this requirement?
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
What is the result of the expression with these selections'?
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....
How many dimensions and measures exist?
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...
How should the analyst create this trigger?
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)
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.)
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
Which option will assist a business analyst while creating the user interface?
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...
Which chart type should the analyst use?
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...
Which two actions must a business analyst perform to create the water fall chart shown?
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...
What is the result?
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...
