Discussion Board for collaboration on QlikView Scripting.
I'm trying to the filter but somehow i get a script error. Please see syntax below
SQL SELECT *
WHERE trndat > '12/31/2011';
Probably date format is wrong, try to use trndat > '20111231';
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;
SELECT Name, Location, Address from xxx where trndat > '12/31/2011';
If this is not the case, please state what error you are getting.
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.
Hi guys managed to filter using the year function instead and it worked just fine ;
WHERE YEAR(notdat) > 2011;