Discussion board where members can get started with QlikView.
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!
from ur datasource:
where urdatefield>'1/1/2016 ';
You need to use Where Clause in Load script,
Where myDateField > $(vMinDate);
If you want only the data after 1/1/2016 than you could put a where condition ,
if you just want to reduce it for only one field then you could use the if condition
from table ;
Hope this helps you