Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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..

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!