Connecting to the database

To load data from the database, we need to create a connection to the database:

1. Use the same QlikView file QlikViewEssentials.qvw that you created in the previous section.
2. Go to the Main tab. Data connections should be created in the Main tab, so that they can be available to all the tabs after the Main tab.
3. Open script editor as shown previously. On the Data tab, select OLE DB from the database drop-down list.
4. If you are working with a Windows 64-bit system, be sure to check Force 32 Bit.
5. Click the Connect button. In Data Link Properties, select Microsoft Jet 4.0 OLE DB Provider as you will be using the Access database, and click Next.
6. Browse to QlikViewEssentials.mdb, which is in the downloaded folder QlikViewEssentials/Data. Click on Test Connection to make sure the connection is correct.
   
7. Connection to the database is successfully created.
   

Loading the OrderHeader Table

The OrderHeader table is a database table. It stores details regarding the order such as order ID...