If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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'));
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
Looks like a simple where clause did the trick, thanks ! 🙂