Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
sample:
load *,
....
....
.....
from ur datasource:
where urdatefield>'1/1/2016 ';
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
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