Limiting Date Range

[#1]

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!

[Chanty4u]

sample:

load *,

....

....

.....

from ur datasource:

where  urdatefield>'1/1/2016 ';

[engishfaque]

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