8 Replies Latest reply: Dec 5, 2014 5:53 AM by barathiraja balashanmugam RSS

    ErrorMsg: Incorrect syntax near 'LOAD'

    Chris Robins

      Hi - I am new to Qlik and attempting to create a date calendar, I keep getting an error message.  Can someone please assist?

       

      Microsoft OLD DB provider SQL Server, ErrorMsg: Incorrect syntax near 'LOAD'

       

      LOAD

      num(Floor(R.date_written)) AS Initial_Date,

      Date(Floor(R.date_written)) AS Calendar_Date,

      Year(R.date_written) AS Year,

      'W' & Ceil(Month(R.date_written) /3) AS Quarter,

      Month((R.date_written) AS Month,

      Day(R.date_written) AS Day,

      Week(R.date_written AS Week,

      WeekStart(R.date_written) AS Week Start

      ;

       

      Any help is appreciated