Syntax Error: Missing/Missplaced

[#1]

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);

[swuehl · Accepted solution]

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);

[#3]

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

[Anil_Babu_Samineni]

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