topic Syntax Error: Missing/Missplaced in QlikView

Syntax Error: Missing/Missplaced

Wed, 25 Nov 2020 16:16:04 GMT

HI I'm new to Qlik so this question might be a silly one. I successfully added a xls file into the data load editor. When I use the Year, Month, Week function I get the missing/missplaced syntax error. I don't really know what the problem is, I was hoping for a little help.

Thanks

[Deposits]:

LOAD [Service Agreement ID],

[SA Type],

[SA Status],

[ACCT_ID],

[Customer Class],

[Current Amount],

[Payoff Amount],

[Deposit_Plus_Int],

year[Start Date] as Year,

month[Start Date] as Month,

week[Start Date] as Week,

[Customer Name]

FROM [lib://AttachedFiles/Customer_Deposits_QlikSense.xlsx]

(ooxml, embedded labels, table is Deposits);

Re: Syntax Error: Missing/Missplaced

swuehl — Tue, 13 Sep 2016 15:55:14 GMT

Try with ()

year([Start Date]) as Year,

month([Start Date]) as Month,

week([Start Date]) as Week,

[Customer Name]

FROM [lib://AttachedFiles/Customer_Deposits_QlikSense.xlsx]

(ooxml, embedded labels, table is Deposits);

Re: Syntax Error: Missing/Missplaced

Tue, 13 Sep 2016 16:11:21 GMT

Thanks Stefan. that cleared my error. I appreciate your help.

Re: Syntax Error: Missing/Missplaced

Anil_Babu_Samineni — Tue, 13 Sep 2016 17:29:45 GMT

Cool, close this thread. Just flag the current answer which solution was resolved.