QlikView QlikView Certification QV_DEVELOPER_01 Questions & Answers

• Question 21:

  Which objects are the most appropriate for setting one or more values for use in a "what-if" scenario?

  A. lnput Box Object and Chart Object

  B. lnput Box Object and Calendar/slider Object

  C. Button Object and Extension Object

  D. Calendar/slider Object and Chart Object

  E. lnput Box Object and Text Object

  Correct Answer: B

• Question 22:

  A customer needs to display sales amounts for the current month and a trend of sales over the prior 12

  months using asmall amountof screenspace.

  Which chart type should the designer use to meets the customer's needs?

  A. a Combo Chart with one expression to display the current month sales and a second expression represented as a Mini Chart to display a trend of sales over the prior 12 months

  B. a Straight Table with one expression to display the current month sales and a second Line Chart to display a trend of sales over the prior 12 months

  C. a Straight Table with one expression to display the current month sales and a second expression represented as a Mini Chart to display a trend of sales over the prior 12 months

  D. a Straight Table with one expression to display the current month sales and a second expression represented as a Linear Gauge to display a trend of sales over the prior 12 months

  Correct Answer: C

• Question 23:

  A customer with a complex chart is experiencing performance issues when the organization's users view

  the chart without first applying several filters.

  A designer needs to place a restriction on the chart so that the users are forced to make a selection before

  QlikView will calculate and render the chart.

  Which common object property can the designer use to accomplish this?

  A. the Help Text property on the Caption tab to enter instructions directing the user to make a selection and filter their data before performing their analysis

  B. the Auto Minimize property on the Caption tab so that the chart will be minimized and not calculate or render until the user has first made a selection and restored the chart

  C. the Calculate Condition property on the General tab to create a control condition that will keep the chart from calculating until user has filtered the data

  D. the size to Data property on the Layout tab to automatically select the filter criteria to the chart

  Correct Answer: C

• Question 24:

  A customer has multiple bar charts comparing different metrics. All charts contain a single Expression all with the Dimension CustomerlD The charts are sorted by Y-Value Descending. Some Customers have Y-Values of zero for some metrics and not others. How can the designer show the same color bar for a single CustomerlD in all the charts?

  A. Properties > Colors and then define colors 1 - 6 with specific RGB values

  B. Properties > Colors and then check the Multicolored and Persistent Colors checkboxes

  C. Properties > Visual Cues and then set the Upper and Lower colors using specific RGB values

  D. Properties > Presentation and then define the Error Bars colors with a specific RGB value

  Correct Answer: B

• Question 25:

  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 designer while creating the user interface?

  A. Go to View menu > Reselect Window > 1280 x 800

  B. Go to View menu > Fit Zoom to Window > 1280 x 800

  C. Go to settings menu > User Preferences > Design Tab and select 1280 x 800

  D. Go to settings menu > User Preferences > Design Tab and select Display Grid Lines

  Correct Answer: A

• Question 26:

  ln which two places in the Chart Properties of a Gauge can expressions be entered? (Choose two.)

  A. Calculation Condition of the object

  B. Number of major/minor units for the scale

  C. show Condition of the object

  D. X and Y position of the object

  E. Auto Minimize of the object

  Correct Answer: AC

• Question 27:

  How can a designer display the field selections that have been made within a chart caption?

  A. by inserting a Current selections box into the Text in Chart B. by using an expression with GetCurrentselections in the Window Title option on the General tab

  C. by using an expression with SET Analysis and the system Fields in the Title Text option on the Caption tab

  D. by selecting show Current selections on the Caption tab

  Correct Answer: B

• Question 28:

  A customer has an Addresses table with the fields. CustomerNumber, CustomerName, AddressLine1,

  AddressLine2, City, StateCode, PostalCode, and CountryCode.

  A designer needs to design a chart to show a count of distinct customers in which the customer's

  CountryCode is US or CA, while ignoring all selections on the Addresses table except the

  CustomerNumber and CustomerName fields.

  How can the designer calculate the required value?

  A. count({$} distinct CustomerNumber)

  B. count({$} distinct CustomerNumber)

  C. count({1} distinct CustomerNumber)

  D. count({$} distinct CustomerNumber)

  E. count({$<(CountryCode={US} or CountryCode={CA}) AddressLine1= AddressLine2= City= StateCode=, PostalCode=>} distinct CustomerNumber)

  Correct Answer: B

• Question 29:

  A customer is building a dashboard to measure the performance of the support organization. The customer needs to dynamically sort the Ticket Severity field by Severity Weight field when the Ticket Severity columnheaderisdouble-clickedinStraightTablecharts. Example ticket severities. Urgent = 1 High = 2 Normal = 3 Low = 4

  Which QlikView load script function can the developer use to create the Ticket Severity field to meet the customer's needs?

  A. Rank( [Ticket Severity], [Severity Weight] ) AS [Ticket Severity]

  B. Num( [Severity Weight], [Ticket Severity] ) AS [Ticket Severity]

  C. Sort( [Ticket Severity], [Severity Weight] ) AS [Ticket Severity]

  D. Dual( [Ticket Severity], [Severity Weight] ) AS [Ticket Severity]

  Correct Answer: D

• Question 30:

  What must a developer consider when loading a table after the section Access statement and before the section Applicationstatement?

  A. All field names must start with a $ sign.

  B. All field names must be written in uppercase.

  C. The field Access must be the first field loaded.

  D. The fields Access, User, and Password must be loaded.

  Correct Answer: B