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?

[#2]

you should always terminate the load statement with a semi colon.

[srchilukoori]

Terminate the following statement with a semicolon

InvoiceAmount - PaidAmount AS InvoiceBalance ;

Just above the SQL Select statement

[#4]

There are several field names that are identical. This means, when your script finishes, there will be synthetic keys. What the guys said before me, also true, that you should use a semicolon when ending your load statement .

Br

T