Qlikview 11 sample question

Tue, 25 Mar 2014 21:56:28 GMT

A developer is attempting to reload a QVW when the script error displays:

Syntax error, missing/misplaced FROM: LOAD InvoiceNo,
DateInvoiced,
Today() - DateInvoiced AS InvoiceAgeInDays,
DateDue,
LastPaymentDate,
InvoiceAmount,
PaidAmount,
InvoiceAmount - PaidAmount AS InvoiceBalance
SQL SELECT InvoiceNo,
DateInvoiced,
DateDue,
LastPaymentDate,
InvoiceAmount,
PaidAmount
FROM dbo.Invoice;
LOAD InvoiceNo,
DateInvoiced,
Today() - DateInvoiced AS InvoiceAgeInDays,
DateDue,
LastPaymentDate,
InvoiceAmount,
PaidAmount,
InvoiceAmount - PaidAmount AS InvoiceBalance
SQL SELECT InvoiceNo,
DateInvoiced,
DateDue,
LastPaymentDate,
InvoiceAmount,
PaidAmount
FROM dbo.Invoice;

How should the developer resolve the error?

> terminate the LOAD statement with a semi-colon (;) at the end of the field list

> add FROM dbo.Invoice to the end of the LOAD prior to the SQL statement

> add Resident Invoice to the end of the LOAD prior to the SQL statement

> move the misplaced FROM line above the LOAD line

Re: Qlikview 11 sample question

chiru_thota — Tue, 25 Mar 2014 22:25:29 GMT

terminate the LOAD statement with a semi-colon (;) at the end of the field list

Re: Qlikview 11 sample question

Tue, 25 Mar 2014 22:37:49 GMT

which line has the error ?

Re: Qlikview 11 sample question

srchilukoori — Wed, 26 Mar 2014 01:08:10 GMT

Terminate with a semicolon after the

InvoiceAmount - PaidAmount AS InvoiceBalance

Just above the SQL Select statement.

topic Re: Qlikview 11 sample question in QlikView

Qlikview 11 sample question

Re: Qlikview 11 sample question

Re: Qlikview 11 sample question

Re: Qlikview 11 sample question