Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Champion III
Champion III

Re: Limiting Date Range

sample:

load *,

....

....

.....

from ur datasource:

where  urdatefield>'1/1/2016 ';

Highlighted
Specialist III
Specialist III

Re: Limiting Date Range

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

Highlighted

Re: Limiting Date Range

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