O'Reilly logo

QlikView Essentials by Chandraish Sinha

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required