Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to limit data during first load?

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

Tags (1)
3 Replies

Re: How to limit data during first load?

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

Not applicable

Re: How to limit data during first load?

MSSQL

And the date field is in datetime format

Re: How to limit data during first load?

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

-Rob

Community Browser