Refer to the exhibit to the right.

A customer has aggregated budgets for products by year and month. Actual data is stored at a more detailed transaction level and so a one-to-many relationship exists between the Budgets to Actuals table.
Budgets have been assigned for all months of the current year, but there are only transactions up to the current month of October. There are transactions for products that were not assigned budgets.
How can a developer remove the synthetic key automatically generated by QlikView and be able to analyze budgets and actuals by product, month, and year?

• A. load the Actuals table, and when loading the Budgets table, use Outer Join to join the BudgetAmount field to the Actuals table
• B. load the Actuals table, and when loading the Budgets table, rename fields Year and Month to BudgetYear and BudgetMonth
• C. create a concatenated key of Product-Year-Month in both the Budgets and Actuals table and comment out the individual fields in the Budgets table
• D. load the Actuals table, and when loading the Budgets table, use the Concatenate function to append the Budgets table to the Actuals table

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 column header is double-clicked in Straight Table charts.
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. Num( [Severity Weight], [Ticket Severity] ) AS [Ticket Severity]
• B. Rank( [Ticket Severity], [Severity Weight] ) AS [Ticket Severity]
• C. Sort( [Ticket Severity], [Severity Weight] ) AS [Ticket Severity]
• D. Dual( [Ticket Severity], [Severity Weight] ) AS [Ticket Severity]

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

Which QlikView feature should a developer use to provide information throughout the QVW application about how a field was calculated in the Load script?

• A. Variable Comment
• B. Field Comment
• C. Expression Comment
• D. Dimension Tag
• E. Field Tag

A designer needs to create a chart displaying the number of patients currently checked into a hospital by age group.
What is the appropriate Dimension for the chart?

• A. age group
• B. number of patients
• C. hospital
• D. checked-in status