topic Re: Load Data Based on Date in QlikView

Load Data Based on Date

Mon, 21 Apr 2014 19:44:07 GMT

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!

Re: Load Data Based on Date

MK_QSL — Mon, 21 Apr 2014 19:46:13 GMT

Load invnum,

....

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

SQL Select *

.....

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

Re: Load Data Based on Date

its_anandrjs — Mon, 21 Apr 2014 19:46:26 GMT

What is your transaction(txdate) date format.

Re: Load Data Based on Date

its_anandrjs — Mon, 21 Apr 2014 19:49:39 GMT

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

Re: Load Data Based on Date

Mon, 21 Apr 2014 20:20:35 GMT

Thanks so much for the quick help!