topic Re: missing expression from SQL in QlikView

missing expression from SQL

markgraham123 — Thu, 29 Oct 2015 18:56:07 GMT

Hi all,

I'm trying to fetch the records which were greater than 10/28/2015 05:10:55 PM from SQL through qlikview script.

I have field "Last updated Date time" which holds that value.

But when i use,

SQL SELECT

FROM Table WHERE DATETIME(LAST_UPDATE_DATETIME) >='10/28/2015';

It's throwing "missing expression from SQL" error.

Can some one please help me to get into the right format.

Re: missing expression from SQL

sinanozdemir — Thu, 29 Oct 2015 19:12:28 GMT

Are you using SQL Server? If so, the query should be like the below:

SQL SELECT

FROM Table WHERE LAST_UPDATE_DATETIME >='2015-10-28';

Re: missing expression from SQL

maxgro — Thu, 29 Oct 2015 19:14:24 GMT

The function (datetime, ....) and format ('10/28/2015') after the SQL depends on the database, not QlikView;

what's the database?

Re: missing expression from SQL

markgraham123 — Thu, 29 Oct 2015 19:16:52 GMT

Maxgro,

It's SQL

Re: missing expression from SQL

markgraham123 — Thu, 29 Oct 2015 19:17:38 GMT

I tried that too bro.

But no luck, same error.

Re: missing expression from SQL

handry_orozco — Thu, 29 Oct 2015 19:17:44 GMT

Try,

Select *

From Table Where DateTime(Cast(Last_Uptdate_Datetime) As Date) >= '10/28/2015'

Bye

Re: missing expression from SQL

markgraham123 — Thu, 29 Oct 2015 19:18:26 GMT

SQL##f - SqlState: S1000, ErrorCode: 936, ErrorMsg: [Oracle][ODBC][Ora]ORA-00936: missing expression

Re: missing expression from SQL

markgraham123 — Thu, 29 Oct 2015 19:19:13 GMT

SQL##f - SqlState: S1000, ErrorCode: 936, ErrorMsg: [Oracle][ODBC][Ora]ORA-00936: missing expression

Re: missing expression from SQL

Thu, 29 Oct 2015 19:21:28 GMT

Graham,

Can you add Attribute names after your select statement & check this link.

https://community.qlik.com/thread/61385

Thanks

Brad.

Re: missing expression from SQL

markgraham123 — Thu, 29 Oct 2015 19:24:26 GMT

I tried that after checking that thread this morning
but no progress

Re: missing expression from SQL

markgraham123 — Thu, 29 Oct 2015 19:27:13 GMT

maxgro‌

Can you please help here

Re: missing expression from SQL

markgraham123 — Thu, 29 Oct 2015 19:29:24 GMT

Throwing below error.

SQL##f - SqlState: S1000, ErrorCode: 905, ErrorMsg: [Oracle][ODBC][Ora]ORA-00905: missing keyword

Re: missing expression from SQL

sinanozdemir — Thu, 29 Oct 2015 19:34:42 GMT

Do you have LAST_UPDATE_DATETIME field in the table though?

Re: missing expression from SQL

markgraham123 — Thu, 29 Oct 2015 19:35:20 GMT

Yes Sinan.

Re: missing expression from SQL

sinanozdemir — Thu, 29 Oct 2015 19:37:17 GMT

What is the table name? Because you are using FROM Table, Table is a reserved word.

Re: missing expression from SQL

markgraham123 — Thu, 29 Oct 2015 19:38:10 GMT

The Table name is "Dealers"

I was just using a dummy name.

Re: missing expression from SQL

markgraham123 — Thu, 29 Oct 2015 19:38:58 GMT

SQL SELECT

FROM "Grade"."Dealers" Where DateTime(Cast(LAST_UPDATE_DATETIME) As Date) >= '10/28/2015';

Re: missing expression from SQL

sinanozdemir — Thu, 29 Oct 2015 19:41:08 GMT

Is it "Grade.Dealers"?

Re: missing expression from SQL

markgraham123 — Thu, 29 Oct 2015 19:42:25 GMT

Grade is the library and Dealers is the table.

I think that part is fine, i was getting trouble only with the format Sinan.

Re: missing expression from SQL

maxgro — Thu, 29 Oct 2015 19:45:54 GMT

Your error says you're using an Oracle database;

but in Oracle I don't find a datetime function SQL Functions

maybe this if LAST_.... is a date

WHERE LAST_UPDATE_DATETIME >= to_date('28/10/2015', 'DD/MM/YYYY')

WHERE LAST_UPDATE_DATETIME > to_date('28/10/2015 00:00:00', 'DD/MM/YYYY HH:MI:SS')