Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

adoteykwame
Contributor

Operator / operand type mismatch....

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';

4 Replies

Re: Operator / operand type mismatch....

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

Luminary
Luminary

Re: Operator / operand type mismatch....

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.

adoteykwame
Contributor

Re: Operator / operand type mismatch....

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.

adoteykwame
Contributor

Re: Operator / operand type mismatch....

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

WHERE YEAR(notdat) > 2011;

Community Browser