Discussion Board for collaboration on QlikView Scripting.
Here is my load statement
Year(soldon) as Year,
Month(soldon) as Month,
Day(soldon) as Day,
SQL SELECT *
I get an error saying
I'm not sure what is wrong with my script, without the WHERE clause it works fine.
Does the where clause just not work in a SQL statement in QV?
Go to Solution.
should work but could take a longer time to load.
It works, but the SQL syntax could be wrong. What data type is soldon in the database ? and what database is this ? (oracle, SQL Server etc...)
apparently this error is obtained.
already dealt with the connection, ODBC or OLE DB, you must apply before your code
I leave this link can help
For most of the Sql based databases date has to be in this format '11-Nov-2014'.
Like this it should be, This is a SQL Query successfully executed on a Oracle Database.
I have an OLE DB connection for Visual FoxPro
I tried to apply the code before the connection, not sure how it's supposed to work but I still get a script error
You could try using the canonical date format 'YYYY-MM-DD', and see if this works.
It may be that your localisation settings are causing the date to be misinterpreted.
Did anyone apply a successfully where clause on a sql statement in qlikview, does anyone know any documentation on that?
I tried applying a different where clause on a simple numeric field and this format keeps giving me an error
Many of us regularly use where clauses in our QlikView SQL extracts.
In this instance it may be that there's an issue with string / numeric conversion. If your locationid field is numeric, try removing the single quotes from your where clause
also, remove the single quotes from around 'trans_act'
This worked for the numeric field, removing the single quotes, now I'm working on formatting the date field for my where clause to work