topic Re: How to limit data during first load? in QlikView

How to limit data during first load?

Thu, 28 Feb 2013 05:35:37 GMT

Hi,

I have this instance that from database, the data I will fetching is more than million of records, and in order to limit the data, I want only to load date that is equal or greater than April 1, 2012

So, this is the syntax:

Load ID,

DOCDATE,

ITEMNO;

SQL Select * from TABLE where DOCDATE >= '4/1/2012';

Is that possible? Say that I am connected to the database that is why I used SQL Select

Thanks for your help!

Regards,

Bill

Re: How to limit data during first load?

rwunderlich — Thu, 28 Feb 2013 05:59:18 GMT

Yes, that is possible. The format of the date string depends on your DBMS. Check your reference documentation for "date literal" or tell us what DBMS you are using.

-Rob

Re: How to limit data during first load?

Thu, 28 Feb 2013 06:06:31 GMT

MSSQL

And the date field is in datetime format

Re: How to limit data during first load?

rwunderlich — Thu, 28 Feb 2013 06:44:45 GMT

WHERE DOCDATE >= '04-01-2012 00:00:00'

-Rob