Assuming you have any database on your computer or server (Access, MySQL, Oracle, or otherwise—these illustrations use the free Microsoft Access 2010 database,
Northwind1, on a system running the 32-bit Office 2010), be sure you have the correct driver on your machine; if you are running the 32 bit Microsoft Office 2010 and accessing the newer format of the Access
.accdb file, you will need to download and install the 32-bit Microsoft Access Database Engine 2010 Redistributable driver. Let's walk through creating a brief script in QlikView's Script Editor window.
To get to the Select Statement dialog, you have to first connect to a database. The following example illustrates a connection to ...