QlikView QV_Developer_01 : QlikView 11 Developer Certification Examination

Refer to the exhibit to the right.

The Sales table displayed in the exhibit represents the entire data set.
Given the expression.
=sum( {$< Month={'Oct'}, RegionID={'4'} >} SalesAmount)
What is the result with the selections for SalesPersonID=1 and RegionID=3?

• A. 4500
• B. 5000
• C. 3500
• D. 0

A developer needs to modify the data model of a document that consumes 5GB of RAM when opened in memory.
Which type of client should the developer use?

• A. QlikView local client on a 64 bit Windows 7 operating system
• B. QlikView local client on a 32 bit Windows 7 operating system
• C. QlikView local client on a 64 bit Mac operating system
• D. Internet Explorer Plug-in client on a 64 bit Windows 7 operating system

A customer created 20 expressions that will be used repetitively throughout a QlikView application. These expressions could appear in more than 50 objects located on 15 tabs.
How can a developer efficiently apply and maintain these expressions?

• A. create a variable for each expression that contains the expression text and use the variable in place of the expression in each object
• B. load the text for each expression from a text file into a table in the data model and link it to the fact table
• C. create a table of indices and expression text and use the index value in place of the expression text in each object
• D. create the required expression in each object as needed and edit them in the Expression Overview

A developer needs to add data from a Microsoft Access database to a data model intended to run on a 64 bit Windows Server.
How should the developer proceed?

• A. from the script editor, on the Data tab, click on the 'database conversion' button and convert the database from a 32 bit to 64 bit database
• B. from the script editor, on the Data tab, under Database choose 'ODBC' from the Database pull down and then click the 'Connect' button
• C. from the script editor, on the Data tab, under Database, choose 'ODBC' from the Database pull down, assure the 'Force 32 bit' check box is selected, and then click the 'Connect' button
• D. from the script editor, on the Data tab, under Database, choose 'ODBC 32 bit' from the Database pull down and then click the 'Connect' button

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 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
• B. the Size to Data property on the Layout tab to automatically size the filter criteria to the chart
• C. 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
• D. 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