Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
qliky88
Creator
Creator

Load data based on a specific date

Hi All, 

 

Just wondering what is the best way/ best practices to load data based on a specific date. I need to do this as my dataset is too large and I am experiencing memory errors. 

 

I want to look at everything after 2018. See my attempt below. 

 

Any help much appreciated as always 🙂 

 

LOAD RECORD_ID,
ID,
NAME,
STATUS,
PRODUCT_ID,
Date(Date#(DATETIME_CREATED,'DD/MMM/YYYY hh:mm:ss')) > Date(Date#('31/12/2018 12:00:00', 'DD/MMM/YYYY hh:mm:ss'));

 

 

Labels (2)
1 Solution

Accepted Solutions
Steven_Haught
Creator III
Creator III

This can be done usually with a simple WHERE clause in your load statement. 

What is the current format of the Field, DATETIME_CREATED?

View solution in original post

2 Replies
Steven_Haught
Creator III
Creator III

This can be done usually with a simple WHERE clause in your load statement. 

What is the current format of the Field, DATETIME_CREATED?

View solution in original post

qliky88
Creator
Creator
Author

Hi @Steven_Haught 

 

Looks like a simple where clause did the trick, thanks ! 🙂