Qlikview 11 sample question

[#1]

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

[chiru_thota]

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

[#3]

which line has the error ?

[srchilukoori]

Terminate with a semicolon after the

InvoiceAmount - PaidAmount AS InvoiceBalance

Just above the SQL Select statement.