topic Re: Qlikview 11 sample question in QlikView

Qlikview 11 sample question

Tue, 25 Mar 2014 21:53:37 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?

Re: Qlikview 11 sample question

Tue, 25 Mar 2014 22:22:44 GMT

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

Re: Qlikview 11 sample question

srchilukoori — Wed, 26 Mar 2014 01:09:31 GMT

Terminate the following statement with a semicolon

InvoiceAmount - PaidAmount AS InvoiceBalance ;

Just above the SQL Select statement

Re: Qlikview 11 sample question

Mon, 15 Dec 2014 12:14:36 GMT

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 .