Question 1

A business analyst creates a document with sales data for different regions, products, and salespeople. The analyst needs to create an object that will show the percentage of the total sales when one or more values are selected.

Which two objects can the analyst use to meet these requirements? (Select two.)

AText box

BTable box

CGauge chart

DMekko chart

EStatistics box

Answer : A, B

Question 2

A business analyst uses a QlikView application developed on a desktop with a screen resolution of 1280 x 800 During weekly meetings the analyst presents the application using a projector with a maximum screen resolution of 1280 x 720 At this resolution, vertical scroll bars are displayed

Which setting can solve the problem?

AView > Turn on Projector View

BView > Fit Zoom to Window > Apply Zoom to All Sheets

CSettings > Document Properties > General Tab and check Disable Scroll Bars

DSettings > Sheet Properties > General Tab and check Fit to Projector Screen Resolution

Answer : D

Question 3

A customer needs to see sales data by month, with a rolling six month average of margin percent for any selected twelve month period. Which chart will meet these requirements?

AA combo chart of sales as bars and rolling six month average margin percent as a line by Month Year

BA pie chart of sales by Month Year and a line chart of rolling six month average margin percent by MonthYear

CA bar chart of sales by month by year and a straight table of rolling six month average margin percent by MonthYear

DA trellis chart of bar charts as sales by month by year and a pivot table of rolling six month average margin percent by month by year

Answer : B

Question 4

What are two ways to calculate the Sales for the ProductCategory. Shoes? {Select two )

AMoney(Sum(<ProductCategory={ ' Shoes * }>SaIes) )

BMoney(Sum({<ProductCategory={'Shoes*}>}Sales))

CMoney(Sum(<?roductCategory={Shoes}>Sales))

DMoney(Sum({<{ProductCategory > = 'Shoes'>}Sales))

EMoney(Sum({<?roductCategory={Shoes}>}Sales) )

Answer : D, E

Question 5

A business analyst needs to calculate the average order value by country. Which two objects meet this requirement? (Select two.)

AList box

BMulti box

CTable box

DStatistics box

EStraight table

Answer : B, C

Free Practice Questions for Qlik QV12BA Exam

Question 1

Question 2

Question 3

Question 4

Question 5