Databases Reference
In-Depth Information
Querying the database
Now that we have established communication with the database via our connection
string, we can begin retrieving data from it using the
Structured Query Language
(SQL)
. QlikView makes it easy for us to create the
Select
statements to build
our queries.
The Create Select Statement wizard
The
Select
statement is used to pull data from the database into our QlikView
document, and tells the DBMS the specific set of data we want. We could just type it
manually, but instead we will use the
Create Select Statement
dialog in order to find
the table we want to read, as well as the fields we need, and automatically populate
the required QlikView script.
Since we've already created the
Connect
statement, we can go ahead and click on the
Select
button from the
Data
tab. The
Create Select Statement
dialog window will
appear. This window is used to specify the database, table, and fields we want to
load. After we click on
OK
, the corresponding
Select
statement will be generated.
Let's look at the components of this particular window, so we know what
each option does. The following screenshot shows the
Create Select Statement
dialog window: