Qlikview Script Notes

Qlikview scripts are executed from top to bottom and from left to right so the tab scripts are executed in the correct order.

One related note about segmentation of the script (and associated QVWs) is that a common architecture is to have a three-tiered QlikView environment:
• Tier 1 application files are the data connection layer. The QVW connects to the database and runs the SQL queries of database tables to generate QVDs.
• Tier 2 is the transformation layer where transformations are performed by tier 2 QVWs with data from tier 1 QVDs. This information is stored in tier 2
data model QVDs.
• Tier 3 is the GUI/presentation layer, which uses tier 2 QVDs for the data model.

* Field names are case sensitive in QlikView, and this is
critical to field linking/associations.
* We can use to rename data fields: the AS specifier, Alias,
Rename Fields, and QUALIFY.

QUALIFY ID;

Customers:
Load ID, Name
From C:\Qlikview\Clients.qvd (qvd);
Concatenate Load ID, Name
From C:\Qlikview\Products.qvd (qvd);
UNQUALIFY *;
The result of the aforementioned Load statement will be a new Customers table
with three data fields: Customers.ID, Products.ID, and Name. The two loads are
concatenated into one QlikView table (Customers).
The wildcard character is useful when using the QUALIFY statement (note the double
quotes), as illustrated in the following example. The wildcard can be used when it is
impractical to list every field name that must be qualified.
QUALIFY “*ID”, Name;
[Customers]:
Load ClientID, Name
From C:\Qlikview\Clients.qvd (qvd);
Load ShippingID, Name
From C:\Qlikview\ShipTo.qvd (qvd);
UNQUALIFY *;

Load// // // // //

resident is used if data should be loaded from a previously loaded table.

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.