topic Re: Operand Type Clash Error in QlikView

Operand Type Clash Error

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I need assistance with an Operand Type Clash Error. Basically, I have a script where data should only load for the maximum date. Below is the script and the error message.

Please can you assist as to why i get this error and how to rectify it.

TMP:

LOAD

max(AsAtDate) as MaxAsAtDate;

SQL SELECT *

FROM "Procurement_ODS".dbo."Business_Unit_Table";

Let vMaxDate = Date(peek('MaxAsAtDate',0,'TMP'),'YYYY/MM/DD');

drop table TMP;

LOAD BusinessUnitId as SEGMENT2,

BusinessUnitName,

SegmentID,

SegmentName,

AsAtDate,

SegmentNameNew,

SegmentIDNew,

Brand,

"BBBEE_IND";

SQL SELECT *

FROM "Procurement_ODS".dbo."Business_Unit_Table"

where SegmentNameNew <> '%global%' and BusinessUnitId <> '6270' and BusinessUnitId <> '8430' and AsAtDate >= $(vMaxDate)

;

Re: Operand Type Clash Error

prieper — Fri, 22 Sep 2017 09:46:25 GMT

Suggest to check the spelling of dates in your SQL-Table, may also be needed to be included in apostrophs.

Re: Operand Type Clash Error

hari8088 — Fri, 22 Sep 2017 09:50:42 GMT

Check the date format of both (i.e ASdate and variable).

In the where condition give like this

AsAtDate >= '$(vMaxDate)';

Re: Operand Type Clash Error

Chanty4u — Fri, 22 Sep 2017 09:51:27 GMT

try to debug the application to know where exactly it is stopping you.

by that you can identify the issue easily.

and chek the variable missing single quotes i believe

Re: Operand Type Clash Error

Anonymous — Fri, 22 Sep 2017 09:52:57 GMT

Hi Peter

Thank you. It worked. I added Apostrophe on the variable AsAtDate >= '$(vMaxDate)' in the where clause.

Kind regards

Nayan