Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am importing data via JSON that has data starting from Aug 2016 and I want to only need data starting from Jan 2017.
I'm not sure if this is something I can change in the master calendar or not.
Thank you!!
-Using Qlik Sense Server
What happens if you add :
[FireX Monthly Inspection]:
LEFT KEEP ([FireX Database])
load * where [CREATED DATE]>='2017-01-01 00:00';
LOAD ID AS [Firex Monthly Inspection Key],
// [PARENT_RECORD_ID] AS [PARENT_RECORD_ID],
// [PARENT_PAGE_ID] AS [PARENT_PAGE_ID],
// [PARENT_ELEMENT_ID] AS [PARENT_ELEMENT_ID],
Date(Floor([CREATED_DATE], 1/(24 * 60)), 'YYYY-MM-DD hh:mm') AS [CREATED DATE],
//Timestamp(Timestamp#([CREATED_DATE], 'YYYY-MM-DD hh:mm:ss'), 'YYYY-MM-DD hh:mm' ) AS [CREATED_DATE],
....
Can you share with as he script you're using?
To try to alter it?
Thanks
Absolutely!
I have attached the JSON script and the calendar script.
Thanks so much for looking into this for me.
Thank you,
What is the table containing the date field? And what is this date field?
We can just load * where (Date>01/01/2017) ;
select ....
from your source
And thus, we'll only import data > Jan 2017
The FireX Monthly Inspection table. the Created_Date is the date bring used in my apps.
What happens if you add :
[FireX Monthly Inspection]:
LEFT KEEP ([FireX Database])
load * where [CREATED DATE]>='2017-01-01 00:00';
LOAD ID AS [Firex Monthly Inspection Key],
// [PARENT_RECORD_ID] AS [PARENT_RECORD_ID],
// [PARENT_PAGE_ID] AS [PARENT_PAGE_ID],
// [PARENT_ELEMENT_ID] AS [PARENT_ELEMENT_ID],
Date(Floor([CREATED_DATE], 1/(24 * 60)), 'YYYY-MM-DD hh:mm') AS [CREATED DATE],
//Timestamp(Timestamp#([CREATED_DATE], 'YYYY-MM-DD hh:mm:ss'), 'YYYY-MM-DD hh:mm' ) AS [CREATED_DATE],
....
Yes! That worked perfectly!
Thank you so much