Discussion board where members can get started with Qlik Sense.
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'
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
You are missing closing parenthesis in the Week(r.date_written) line
Sorry, that was a typo. Even with the parenthesis, it still does not work.
next possibility. error message indicates a sql server error. Load is not a sql server command. I would assume your command would be a SQL SELECT and not a load if coming from database.
Look at your Month(
Month(R.date_written) AS Month,
Week(R.date_written) AS Week,
WeekStart(R.date_written) AS Week_Start
am i missing something or there is no table specified in load statement.
i think it should be resident table syntax at the end of load statement.
Specify load from what.
I see an OLEDB error, I think before this there is a connection statement. Do you get Connected displayed?
Is the connection failing?
Also did not see SQL for table as well as any spreadsheet, what is your source?
Do specify the source connection, that is from where its loaded!