A global sales organization needs sales figures in both the local currencies and the corporate standard of
$USD.
How can a developer achieve this goal and enable users to only consume a single Document CAL?
A. create a separate QVW containing values in the data model for both the local and $USD currency amounts
B. create a single QVW and add a table containing currency multipliers while using $USD as a baseline currency
C. create a separate QVW for each currency ($USD is considered its own currency) and document chain them all together
D. create a single QVW with duplicate tables for each currency in data islands and associate each data island to each user or group
Refer to the exhibit to the right.
A customer needs the data displayed in the exhibit loaded into QlikView for analysis. The data is stored in
a fat file and new rows are appended daily.
Which two data quality issues will a developer have to resolve? (Choose two.)
A. the Transaction lD field name contains a space
B. one or more Product field values contain spaces
C. the Date field values contain special characters
D. one or more header rows are included in the file data
E. one or more Product field values contain the file delimiter
F. the Date field name is also a function name and is a reserved word
Refer to the exhibit to the right.
What is the cardinality of the relationship between CUSTOMER and ACCOUNT?
A. many-to-many
B. one-to-many
C. one-to-none
D. one-to-one
Refer to the exhibit below.
A QlikView report does not match the legacy report it was designed to replace. The purpose of the report
is to count the number of customers per year and in total.
Why is there a difference between the Total row values in the two reports?
A. The legacy report calculates the total customer occurrences, while the QlikView report counts only distinct customers.
B. The legacy report calculates the total customer occurrences, while the QlikView report calculates the customer ranking.
C. The legacy report totals the number of customers correctly, while the QlikView report is dropping records.
D. The legacy report totals the number of customers correctly, while the QlikView total row is set to sum of rows.
An Address Book table has a Country Code field. A standard lookup table exists in Excel to translate the
Country Code to a Country description.
The Country Code will be US for any Address Book record with no Country Code value.
Which technique should a developer use to ensure a Country description is loaded for all Address Book
records?
A. load the Address Book records and perform a Left Join of the Excel data to the Address Book table
B. load the Excel data and then load the Address Book data ensuring the Country Code field has the same name in both tables
C. load the Excel data as a Mapping table and use Applymap with a default mapping value when loading the Address Booktable
D. load the Excel data, then load the Address Book data using an lf function to default Country Code to US, and then use the Peek function to retrieve the Country description
A customer has data tables for financial results, staffing, sanitary conditions, and customer satisfaction.
Each table contains a date field and a location lD. Not all dates appear in all tables.
How can a developer create a master calendar that can be used with all the tables?
A. Designate one of the date fields as the reference Build a calendar spanning the minimum and maximum dates in that table Rename all other date fields to match the reference field Left join the location lD from each table into the calendar table on the date fields Drop the location and date fields from all other tables
B. Find the minimum and maximum dates spanned by all tables Create a calendar spanning those dates Rename all other date fields to match the reference field Left join the location lD from each table into the calendar table on the date fields Drop the location and date fields from all other tables
C. Designate one of the date fields as the reference Build a calendar spanning the minimum and maximum dates in that table Rename all other date fields to match the reference field Create a link table with a key of Location and date that contains all unique locations and dates Create a key of location and date in the other tables
D. Find the minimum and maximum dates spanned by all tables Create a calendar spanning those dates Create a link table with a key of location and date that contains all unique locations and dates Create a key of location and date in the other tables Drop the location and date fields from all other tables
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
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
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. Field Tag
B. Field Comment
C. Dimension Tag
D. Variable Comment
E. Expression Comment
An invoices table has a DaysOverdue field. A chart is required to analyze overdue invoices in 30 day
intervals.
Which function should a designer use within a chart to meet this requirement?
A. Class(DaysOverdue30)
B. Aggr(DaysOverdue30)
C. GroupBy(DaysOverdue30)
D. lntervalMatch(DaysOverdue30)
