QlikView 11 Developer Certification Examination Sample Questions:

1. A customer has multiple bar charts comparing different metrics. All charts contain a single Expression all with the Dimension CustomerID.
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 CustomerID in all the charts?

A) Properties > Visual Cues and then set the Upper and Lower colors using specific RGB values
B) Properties > Colors and then define colors 1 - 6 with specific RGB values
C) Properties > Colors and then check the Multicolored and Persistent Colors checkboxes
D) Properties > Presentation and then define the Error Bars colors with a specific RGB value

2. What is the interpretation of a 98 percent subset ratio in the CustomerID field in an Orders table when the subset ratio of the same field in the Customer table is 100 percent?

A) 98 percent of the orders have customers in the data, but only 2 percent of the orders have been shipped
B) 2 percent of the orders have customers in the data, but 100 percent of the customers have placed an order
C) 100 percent of customers are defined in the Customer table, but 2 percent of the customers have not placed an order
D) 98 percent of the customers are defined in the Customer table, but 2 percent of the customers have not placed an order

3. 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 with GROUP BY on SalesTeam
B) a report that uses current selections where the user selects each SalesTeam in turn
C) separate reports with where clauses for each SalesTeam
D) a report with banding on SalesTeam
E) separate reports referencing bookmarks for each SalesTeam

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

5. A Straight Table Chart calculates several metrics for each individual alphanumeric transaction detail record (TRAN_ID) and its Amount over several years of data. The calculation time for the chart is over two minutes.
How can a designer decrease the calculation time for the chart without compromising core functionality?

A) create a Calculation Condition. =sum(Amount) > 0
B) create a Calculation Condition. =count(TRAN_ID) <= 10000
C) create a Calculation Condition. =TRAN_ID < 10000
D) create a Calculation Condition. =sum(TRAN_ID) <= 10000

Solutions: