topic Operator / operand type mismatch.... in QlikView

Operator / operand type mismatch....

Anonymous — Fri, 24 May 2013 11:49:49 GMT

Hi,

I'm trying to the filter but somehow i get a script error. Please see syntax below

LOAD name,

location,

address;

SQL SELECT *

FROM XXX

WHERE trndat > '12/31/2011';

Re: Operator / operand type mismatch....

alexandros17 — Fri, 24 May 2013 11:52:25 GMT

Probably date format is wrong, try to use trndat > '20111231';

Re: Operator / operand type mismatch....

jvitantonio — Fri, 24 May 2013 11:53:36 GMT

Hi, just in case don't use * in your SQL statement. Names in SQL statement will be loaded in upper case. Do this:

LOAD NAME as Name,

LOCATION as Location,

ADDRESS as Address;

SQL

SELECT Name, Location, Address from xxx where trndat > '12/31/2011';

If this is not the case, please state what error you are getting.

Re: Operator / operand type mismatch....

Anonymous — Fri, 24 May 2013 12:10:22 GMT

Yes i have tried with that format,I'm extracting from Foxpro (.bdf) and "command is missing required clause" when i executed with the latter solution.

Re: Operator / operand type mismatch....

Anonymous — Fri, 24 May 2013 14:18:10 GMT

Hi guys managed to filter using the year function instead and it worked just fine ;

WHERE YEAR(notdat) > 2011;