QV12BA QlikView 12 Business Analyst Certification Exam

Loading demo links...

Showing 7–9 of 10 questions

Question 7

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?

Select an option, then click Submit answer.

  • Pivot table with allow pivoting

  • Line chart with style option fill

  • Straight table with dimension limit

  • Radar chart with style option stacked


Question 8

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?

Select an option, then click Submit answer.

  • =Sum(Sales) >200000

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

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

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


Question 9

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?

Select an option, then click Submit answer.

  • Sum({}Sales)

  • Sum({}Sales)

  • Sum(Aggr(Sum(Sales),Max(Year)-1))

  • Sum(Aggr