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({$<(CountryCode={US} or CountryCode={CA}), AddressLine1=, AddressLine2=, City=, StateCode=, PostalCode=>} distinct CustomerNumber)
• B. count({$<CountryCode={US or CA}, AddressLine1=, AddressLine2=, City=, StateCode=, PostalCode=>} distinct CustomerNumber)
• C. count({1<CountryCode={US, CA}, CustomerName=CustomerName, CustomerNumber=CustomerNumber>} distinct CustomerNumber)
• D. count({$<CountryCode={US, CA}, Addresses.*=>} distinct CustomerNumber)
• E. count({$<CountryCode={US, CA}, AddressLine1=, AddressLine2=, City=, StateCode=, PostalCode=>} distinct CustomerNumber)

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 Mac operating system
• B. QlikView local client on a 64 bit Windows 7 operating system
• C. Internet Explorer Plug-in client on a 64 bit Windows 7 operating system
• D. QlikView local client on a 32 bit Windows 7 operating system

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

• A. Auto Minimize of the object
• B. Number of major/minor units for the scale
• C. X and Y position of the object
• D. Calculation Condition of the object
• E. Show Condition of the object

A project to develop a QlikView application for a customer requires splitting developers into two teams.
One team will focus on developing source database query knowledge to create a reusable data layer. There are several application-specific business rules for this project. The customer needs to incrementally accumulate history for the QlikView application over time.
The second team will focus on developing the presentation layer. This team also has data modeling and scripting expertise, but does not have source database query knowledge.
Which data loading strategy should the developers use on the project?

• A. create the presentation layer QVW and connect directly to the source data and apply the business rules in the script
• B. create QVDs of the source data and load them into the presentation layer QVW and apply the business rules in the script
• C. create a series of QVWs that apply the business rules and then binary load them into the presentation layer QVW
• D. create QVDs of the source data, apply the business rules and store a second layer of QVDs, and then load these QVDs into the presentation layer QVW

A customer needs to produce formatted output as a PDF to distribute it to non-QlikView
users.
Each page should show sales trending for a different sales team.
The number of sales teams will change frequently.
What should a developer create to efficiently enable users to create the required output?

• A. a report that uses current selections where the user selects each SalesTeam in turn
• B. separate reports with where clauses for each SalesTeam
• C. separate reports referencing bookmarks for each SalesTeam
• D. a report with banding on SalesTeam
• E. a report with GROUP BY on SalesTeam