topic Re: Limiting Date Range in QlikView

Limiting Date Range

Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Limiting Date Range

Chanty4u — Thu, 24 Mar 2016 18:30:05 GMT

sample:

load *,

....

.....

from ur datasource:

where urdatefield>'1/1/2016 ';

Re: Limiting Date Range

engishfaque — Mon, 28 Mar 2016 04:15:04 GMT

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

Re: Limiting Date Range

avinashelite — Mon, 28 Mar 2016 05:30:57 GMT

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