O'Reilly logo

QlikView Scripting by Matt Floyd

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

Creating the Select statement

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.

Connecting to the database

To get to the Select Statement dialog, you have to first connect to a database. The following example illustrates a connection to ...

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