Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Limiting Date Range

Hello everyone, I'm new to QlikView and have a question about limiting dates. I'd like to only see data starting with 1/1/2016 and going forward in my DATE field of my table. Any advice on how to script this is welcome. Thanks!

3 Replies
Chanty4u
MVP
MVP

sample:

load *,

....

....

.....

from ur datasource:

where  urdatefield>'1/1/2016 ';

engishfaque
Specialist III
Specialist III

Dear Drew,

You need to use Where Clause in Load script,

Example:

--

LET vMinDate = Num(Date('01/01/2015','DD/MM/YYYY'));

taqble:

Load

        *

From yourFile

Where myDateField > $(vMinDate);

Kind regards,

Ishfaque Ahmed

avinashelite

If you want only the data after 1/1/2016 than you could put a where condition ,

Table:

LOAD *

from table

where Date(date_field,'DD-MM-YYYY')>='01-01-2016'

if you just want to reduce it for only one field then you could use the if condition

Table:

LOAD *,

if(Date(date_field,'DD-MM-YYYY')>='01-01-2016',date_field);

from table ;


Hope this helps you