Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load Data Based on Date

Hi!

I'm a Qlikview novice, looking to build my first (non-demo data) App.  I want to Load data from our "invoice table" only if the transaction date (txdate) is greater than 1/1/2010.  Looking at the example of this table in the select window, my txdate data appears to be in a M/D/YYY format.  I have looked at various where statement suggestions on the community pages and haven't seen anything that matches my query exactly.  I am looking for a statement, and also what lines to add the statement to (i.e. where do I put the statement?)  Please see PDF of script editor for additional detail.

Thanks in advance for any help!

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Load  invnum,

       ....

....

Where txdate >= Date('1/1/2010');

SQL Select *

.....

only If your txdate is in M/D/YYY format..

View solution in original post

4 Replies
MK_QSL
MVP
MVP

Load  invnum,

       ....

....

Where txdate >= Date('1/1/2010');

SQL Select *

.....

only If your txdate is in M/D/YYY format..

View solution in original post

its_anandrjs

What is your transaction(txdate) date format.

its_anandrjs

Load table like

If date format is different then use SET syntax and followed by load statements

SET DateFormat='M/D/YYYY';

Load

Statements

..

..

..

Where txdate >= '1/1/2010'

...

...

SQL SELECT *

FROM logongm.invoice

Not applicable
Author

Thanks so much for the quick help!