topic Where Statement Failed in OLEDB - ErrorMsg: Operand type clash: date is incompatible with int in QlikView

Where Statement Failed in OLEDB - ErrorMsg: Operand type clash: date is incompatible with int

Fri, 05 Dec 2014 09:51:10 GMT

Hi,

I am trying to get data from SQL table which fills t-1. days' datas inside. For example, in 5th Dec. i am getting 4th Dec data. And in 6th Dec. i am only getting 5th data.

I want to collect these datas inside qlikview and look like this:

Header 1	Header 2
2014-12-03	1000000
2014-12-04	234545

After initial load from Sql table, i erase query and create 3 sheets that contains queries in Qlikview.

in QV:

1- Initial Load Page:

//log_rapor:

//SQL SELECT *

//FROM SQL.dbo."Logs_T_1";

//Store log_rapor into qvd\Lograpor.qvd(qvd);

//Drop Table log_rapor;

2- Load Main QVD Page:

Main_log_rapor1:

LOAD

Insert_date,

scenario_id,

label,

action,

Adet

FROM

[qvd\Lograpor.qvd]

(qvd);

TMP_MaxDate:

LOAD Max(Insert_date) as Max_date

FROM [qvd\Lograpor.qvd]

(qvd);

//LET vUpdateDate = Peek('Max_date');

LET vUpdateDate = Date(Peek('Max_date'),'YYYY-MM-DD');

DROP Table TMP_MaxDate;

3- Incremental Load Page:

OLEDB CONNECT TO (.........)

Incremental:

NoConcatenate

SQL SELECT Insert_date,

scenario_id,

label,

action,

Adet

FROM SQL.dbo."Logs_T_1"

WHERE Insert_date > $(vUpdateDate);

4-Update Main QVD Page:

Concatenate

LOAD

Insert_date,

scenario_id,

label,

action,

Adet

FROM

[qvd\Lograpor.qvd]

(qvd);

STORE Incremental into [qvd\Lograpor.qvd](qvd);

drop table Incremental;

--------------------------------------

I am getting error like this:

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Operand type clash: date is incompatible with int

Incremental:

NoConcatenate

SQL SELECT Insert_date,

scenario_id,

label,

action,

Adet

FROM SQL.dbo."Logs_T_1"

WHERE Insert_date > 2014-12-04

Where the error can occur? I have been trying from yesterday, bu couln't figured out.

Can anyone help me on this?

Thanks in advance.

Ozan.

Re: Where Statement Failed in OLEDB - ErrorMsg: Operand type clash: date is incompatible with int

tresB — Fri, 05 Dec 2014 10:06:12 GMT

Try enclosing the date within quotes like:

WHERE Insert_date > '2014-12-04'; // assuming the date format here is similar to the one in database

Re: Where Statement Failed in OLEDB - ErrorMsg: Operand type clash: date is incompatible with int

Fri, 05 Dec 2014 10:44:00 GMT

Tresesco, thanks for the help.

The query is getting last day now when writing WHERE Insert_date > '2014-12-04'; // i didnt get any errors.

But is it possible use like WHERE Insert_date > $(vUpdateDate)?

I guess that there occurs a problem when while using vUpdateDate. How can I get the last day automatically?

Thanks.

Re: Where Statement Failed in OLEDB - ErrorMsg: Operand type clash: date is incompatible with int

tresB — Fri, 05 Dec 2014 10:47:30 GMT

May be like:

Let vUpdateDate=Date(Today()-1, 'YYYY-MM-DD')

and then

....

WHERE Insert_date > '$(vUpdateDate)';

Re: Where Statement Failed in OLEDB - ErrorMsg: Operand type clash: date is incompatible with int

Fri, 05 Dec 2014 14:02:25 GMT

Thanks Tresco,

i used

WHERE Insert_date > '$(vUpdateDate)'; instead of WHERE Insert_date > $(vUpdateDate);

and

LET vUpdateDate = Date(Max_date, 'YYYY-MM-DD');

it worked.