Databases Reference
In-Depth Information
The script will look like the following:
[Main Data]:
LOAD
...Field Names...
...Field Names...
...Field Names...
FROM
[..\Data Files\QVDs\Flight Data.QVD]
(qvd);
The
Load
statement is composed of:
° The names of the fields we want to load from the source table.
° The
From
statement, specifying the location of the file we want
to read. The location can be specified either as a full path or a
relative path.
° The attributes we set about the file for QlikView to load it
appropriately. In this case, this part contains only the string (
qvd
).
In other cases it may include other important properties. We will
cover this in more detail in
Chapter 3
,
Data Sources
.
7.
We will now reload the script for the data to be loaded into the QlikView
document so we can start working with it. However, before we do that, it's
a good practice to hit the
Save
button so we do not lose the changes if the
script execution goes wrong.
After saving the file, locate the
Reload
button, shown in the following
screenshot, in the toolbar at the top and click on it.
8.
After the script execution, the
Sheet Properties
window will appear. We will
use it in the next section, but for now just click on
OK
to dismiss it.
Our data model now contains the
Main Data
table.
Playing with listboxes
The first object we will look at in this tutorial is the listbox. A listbox is the most basic
of all QlikView objects and contains all the occurring values for a given field in the
data model. As demonstrated in
Chapter 1
,
Meet QlikView
, a listbox is used to make
selections in the document and filter the data.