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 ...

Get QlikView Essentials now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.