Qlik QV12BA Exam Questions Instant Access

Question 1

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 )

AAdd five dimensions *

BAdd five measures

CCheck 'Show as water fall' on the Style tab of the bar chart properties

DOn the dimension limit properties sheet set limit to only show the first five values .

EUse the Bar Offset property with the correct expression

Answer : C, E

Question 2

Refer to the exhibit

A business analyst needs to present the actual sales of the current year in a KPI on a dashboard. The expression in the Text field is NOT working

Which two changes will correct the expression? (Select two )

ARemove the $ sign before Year

BRemove the $ sign between {and (

CAdd single quotes around the whole expression

DChange Representation from Text to Expression

EAdd a = sign at the beginning of the expression

Answer : A, B

Question 3

A business analyst needs to open another GlikView document by trigger Which two options can be used to perform this task? (Select two.)

AText box trigger

BField event trigger

CLine object trigger

DActivate sheet trigger

EVariable event trigger

Answer : D, E

Question 4

A business analyst wants to represent the relationship between two key performance indicators

How should the business analyst meet these requirements?

ACreate a bar chart with a logarithmic scale

BCreate a table chart with rounding function

CCreate a combo chart with two different scales

DCreate a matrix chart with two different symbols

Answer : D

Question 5

A data model contains 1 billion records and a straight table renders all of the data at the most granular level. The business users do NOT need all of the detailed information. The business analyst needs to improve the rendering time of the straight table.

Which two approaches should the analyst use? (Select two )

AUpdate the straight table to a more summarized view

BReplace all table fields with only one field which concatenates the values of all previous table fields

CRemove all master dimensions and master measures, and replace with distinct expressions in each visualization

DSpecify a specific sort order in the output of the straight table using a field not found in the straight table columns

ESet up a calculation condition to only show the straight table if filtered down to a much smaller number of rows (e.g., 100k rows)

Answer : C, E

Question 6

Two of the tables in the QlikView data model are InvoiceHeader (one million rows) and InvoiceDetail (nine million rows) InvoicelD links the two Invoice tables.

This expression is used several times in the QlikView application, count (distinct invoiceiT)

How can a business analyst optimize this expression for use in the application?

AIn the load script, sort the InvoiceDetail table by InvoicelD. Add if (Peek(invoiceiD)=invoiceiD, 0,1) as DistinctlnvoicelD. Change the expression to Sum(DistinctinvoiceiD)

BIn the load script, add I as DistinctlnvoicelD to the InvoiceDetail table. Change the expression to Sum(DistinctlnvoicelD)

CIn the load script, sort the InvoiceDetail table by InvoicelD. Add if (?eek(invoiceiD)=invoiceiD, 1,0) as DistinctlnvoicelD. Change the expression to Sum (DistinctlnvoicelD)

DIn the load script, add l as DistinctlnvoicelD to the InvoiceHeader table Change the expression to Sum(DistinctlnvoicelD)A.

Answer : D

Question 7

Refer to the exhibit.

The dataset shown has been loaded into a QhkView application The user has selected the year 7015' to analyze

This expression is used to calculate a value:

Num((Sum({!<[Month] = {'May'} >> SalesAmt-COGS)/Sum({1<[Month] = {'May*} >} SalesAmt)), #,##0.0**)

What is the result?

A13 5%

B22.5%

C34.8%

D77.5%

Answer : D

QlikView 12 Business Analyst Certification QV12BA Exam Questions