Number of patients
On the Dimensions tab, press the Add Calculated Dimension button
On the Expressions tab, add an expression using the Class function
On the Expressions tab, add an expression using the Aggr function
On the Dimensions tab, press the Add Dynamic Dimension button
A language definition table in the data model containing all descriptions for each language, and the option to select a specific language in a field
A separate document for each language
Variables for language-specific items and the option to select a specific language in a field
A language definition table in the data model containing all descriptions for each language, automatically linking the business user to a language
Convert the QVW application into a .mob document on the server
Ensure that screen resolution is appropriate for the device
Convert the QVW application into a HTML5 document
Create a specific QVW application for each device
Use only sheet objects suitable for tablet devices
A report with banding on SalesTeam
A report with GROUP BY on SalesTeam
Separate reports with where clauses for each SalesTeam
Separate reports referencing bookmarks for each SalesTeam
A report that uses current selections where the user selects each SalesTeam in turn
Create a separate QVW containing values in the data model for both the local and $USD currency amounts
Create a single QVW and add a table containing currency multipliers while using $USD as a baseline currency
Create a separate QVW for each currency ($USD is considered its own currency) and document chain them all together
Create a single QVW with duplicate tables for each currency in data islands and associate each data island to each user or group
Multiple spellings of the same City
The City value London is associated with two different Country values
The Country values and SalesOrderID values do not relate properly
The SalesAmount field name does not contain a space
Inconsistent Country abbreviations
Duplicate key values
The Transaction ID field name contains a space
One or more Product field values contain spaces
The Date field values contain special characters
One or more header rows are included in the file data
One or more Product field values contain the file delimiter
The Date field name is also a function name and is a reserved word
1; 2; 3
1100; 1300; 2210; 2250; 3125; 3130; 3120
1,100; 1,300; 2,210; 2,250; 3,125; 3,130; 3,120
Change the default DateFormat variable assignment on the Main script tab
Use the Date function to format the field during load
Use the Alt function with different Date# functions
Use the Lookup function with a format table
The field formats (such as numeric or string) must be the same in the original data sources.
The fields must be defined as primary or foreign keys in the original data sources.
The fields must be aliased to the same name when loading into QlikView.
The number of distinct values in each field must be the same.
Convert numeric fields into text fields using the Text function
Combine multiple fields into one complex field, reducing the number of fields per table
Make all numeric fields a fixed length by left padding with leading 0's using the Num function
Split out a single complex field into multiple fields reducing the number of distinct values per field
ACCOUNT_ID and TRANS_SEQ
ACCOUNT_ID, TRANS_SEQ, and TRANS_TYPE
The snowflake schema has been transformed into a de-normalized schema.
The snowflake schema has been transformed into a normalized schema.
The star schema has been transformed into a de-normalized schema.
The star schema has been transformed into a normalized schema.
There will be a relationship between all the tables without synthetic key tables or loosely coupled tables.
There will be a relationship between four of the five tables and one table will be a data island.
There will be a synthetic key table in the data model.
There will be loosely coupled tables in the data model.
Load the tables leaving the automatic associations
Comment out the AssignedTo from the Orders table
Comment out the AssignedTo from the Customer table
Use Rename Field syntax to alias one of the AssignedTo fields
Create a concatenated key of CustomerID and AssignedTo in both tables
Build a Link Table to connect the four transaction tables and add a summary table with precalculated counts, totals, and averages
Build a Link Table to connect the four transaction tables and alias fields that must be kept in their respective table
Concatenate the four transaction tables and add a summary table with pre-calculated counts, totals, and averages
Concatenate the four transaction tables and add fields to identify the record type and count flag
Keep the four transaction tables separate and qualify the names to control correct linkage
Load the Actuals table, and when loading the Budgets table, use Outer Join to join the BudgetAmount field to the Actuals table
Load the Actuals table, and when loading the Budgets table, rename fields Year and Month to BudgetYear and BudgetMonth
Load the Actuals table, and when loading the Budgets table, use the Concatenate function to append the Budgets table to the Actuals table
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
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
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
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
From the script editor, on the Data tab, under Database choose 'ODBC' from the Database pull down and then click the 'Connect' button
By using Input Box to enter the lookup table
By using AutoGenerate to load the lookup table
By generating a lookup table using the Inline wizard
By loading the lookup table using an Include statement
Qualify all tables
Alias all primary key fields
Left join the Customer data onto the Sales table
Qualify all tables and then unqualify all key fields
Qualify both tables and Unqualify all shared fields
Left join the Budgeted Sales table onto the fact table using Month as the key
Concatenate Load the Budgeted Sales table into the Actual Sales table loading shared fields as NULL
Create a link table containing the dimensional fields then link each fact table using a concatenated key
Qualify all the fields in the data model ending with 'ID'
Qualify the fields Name, Address, City, and Country in the Shippers and Suppliers tables
Rename the fields ShipperID in the Shippers table and SupplierID in the Suppliers table
Rename the fields OrderID in the OrderDetails table and SupplierID in the Products table
Save the target names and values in an external file, load them into a QlikView table, and use a FOR loop to assign the values to variables
Manually create a variable for each value in Expression Overview and maintain them in Expression Overview
Create a Variables tab in the load script and use 30 LET statements to assign the values to variables
Embed the target values into each expression in which they are required