Free QV12BA – QlikView 12 Business Analyst Certification Exam Practice Test Question

Select all that apply, then click Submit answer.

• ○

  Bar chart

• ○

  Grid chart

• ○

  Gauge chart

• ○

  Scatter chart

• ○

  Straight table
  
  
  

Select all that apply, then click Submit answer.

• ○

  List box

• ○

  Input box

• ○

  Muiti box

• ○

  Table box

• ○

  Statistics box
  
  
  

Select all that apply, then click Submit answer.

• ○

  Exhibit A

• ○

  Exhibit B

• ○

  Exhibit C

• ○

  Exhibit D

• ○

  Exhibit E
  
  
  

Select all that apply, then click Submit answer.

• ○

  Auto Minimize of the object

• ○

  Show Condition of the object

• ○

  X and Y position of the object

• ○

  Calculation Condition of the object

• ○

  Number of major/minor units for the scale
  
  
  

Select all that apply, then click Submit answer.

• ○

  In the Dimensions tab, check Show All Values

• ○

  In the Expressions tab, check Text as Pop-up

• ○

  In the Presentation tab, check Pop-up Labels

• ○

  In the Expressions tab, check Values on Data Points

• ○

  In the Presentation tab, check Show Numbers in Legend
  
  
  

Select an option, then click Submit answer.

• ○

  The Interval table will be joined with the Transactions table

• ○

  The TransactionTime table will be joined with the Interval table

• ○

  The Interval table will be associated with the Transactions table on the TransactionTime field and with the TimePeriods table by a synthetic table

• ○

  The Interval table will be associated with the Transactions table on the TimePeriods field, and with the TransactionTime table by a synthetic table
  
  
  

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
  
  
  

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)
  
  
  

Select an option, then click Submit answer.

• ○

  Sum({}Sales)

• ○

  Sum({}Sales)

• ○

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

• ○

  Sum(Aggr
  
  
  

Select an option, then click Submit answer.

• ○

  Composite dimension

• ○

  Slowly changing dimension

• ○

  Historical lookup dimension

• ○

  Interval matching dimension