Change date range when importing data

[hammermill21]

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

[OmarBenSalem]

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

To try to alter it?

Thanks

[hammermill21]

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]

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

[OmarBenSalem · Accepted solution]

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]

Yes! That worked perfectly!

Thank you so much