Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hammermill21
Creator III
Creator III

Change date range when importing data

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

1 Solution

Accepted Solutions
OmarBenSalem

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],

....

View solution in original post

6 Replies
OmarBenSalem

Can you share with as he script you're using?

To try to alter it?

Thanks

hammermill21
Creator III
Creator III
Author

Absolutely!

I have attached the JSON script and the calendar script.

Thanks so much for looking into this for me.

OmarBenSalem

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

hammermill21
Creator III
Creator III
Author

The FireX Monthly Inspection table. the Created_Date is the date bring used in my apps.

OmarBenSalem

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],

....

hammermill21
Creator III
Creator III
Author

Yes! That worked perfectly!

Thank you so much