QlikView for Devs ch. 12

happyjoshua777 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I was trying to set up a binary load, cliked QlikViewFile and created this:

Binary [..\QlikView Development\airline operations\2.workbooks\qvd extract - dimension tables.qvw];

// the rest of Resident Load looks like this:

SalesData:

LOAD

InvoiceNumber,

Date,

SalesPerson,

Department,

Amount as InvoiceAmount;

SQL SELECT * FROM DataBaseName.dbo.Sales;

SalesTotals:

LOAD

Department,

Sum(InvoiceAmount) as TotalAmount

Resident SalesData

Group By Department;

When I run this code I receive:

There is no open data connection. Missing or failed "CONNECT" statement.

SQL SELECT * FROM DataBaseName.dbo.Sales

a) Is this due to QlikView not being able to run the SELECT query above?

b) The book does not seem to provide any database (MDBs?) to test this SELECT query. can anyone suggest where to download an example of Sales table in a data file (MDBs)?

thanks

topic QlikView for Devs ch. 12 in QlikView

QlikView for Devs ch. 12