Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Applicable88
Creator III
Creator III

Only load masterdata with a date greater than given

Hello,

I wanted to load my dates only greater than the date 01.10.2020 in this format.

My loading script from Datawarehoue:

[Masterdata]:
LOAD
Serialnumber,
Date(Timestamp#(replace( Finishtime,' UTC',''),'YYYY-MM-DD hh:mm:ss'), 'DD.MM.YYYY') as Finishtime
FROM [lib://XXXXXXXXXXX]
(txt, utf8, embedded labels, delimiter is ',', msq)

Where Date(Timestamp#(replace( Finishtime,' UTC',''),'YYYY-MM-DD hh:mm:ss'), 'DD.MM.YYYY') > Date(Timestamp#(replace( Finishtime,' UTC',''),'2020-10-01 00:00:00'), 'DD.MM.YYYY')
;

Please disregard the fact that I have to use the replace function to get rid of the "UTC" since it arrives in qlik as a string and not date format. 

I already put in the "bigger than 2020-10-01", but still I get no returns. 

Hope someone knows why. 

Thank you in advance. 

0 Replies