Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Filter by date in script

Hi,

I need to load a excel file via load script, by filtering by a date field, i.e. Fecha > "01-05-2014 00:00:00".

I don't know how filter data neither how manage this date format

Any help?

Thanks in advance

Tags (3)
1 Solution

Accepted Solutions
Highlighted

Re: Filter by date in script

Hi

You may try

load *

From <excel fie>

where Fecha > 01-05-2014 00:00:00


If possible try to post your sample here. to get faster reply.

Regards

ASHFAQ

View solution in original post

5 Replies
Highlighted

Re: Filter by date in script

Hi

You may try

load *

From <excel fie>

where Fecha > 01-05-2014 00:00:00


If possible try to post your sample here. to get faster reply.

Regards

ASHFAQ

View solution in original post

Highlighted
Champion III
Champion III

Re: Filter by date in script

Date "likes" to be in the single quotes:

where Fecha > '01-05-2014 00:00:00'

Highlighted
Not applicable

Re: Filter by date in script

Thanks a lot!!!

Highlighted
Not applicable

Re: Filter by date in script

Thanks a lot!!!

Highlighted
Contributor II
Contributor II

Re: Filter by date in script

Can you help me out where i want to set date filter

 

Case1:
Select Id,
Case_Type__c,
LastModifiedDate,
CreatedDate,
Origin,
Status,
Subject from Case where Date(CreatedDate,'DD-MM-YYYY')>='01-05-2018';

CaseHistory1:
Select Id,
CaseId,
CreatedDate,
Field,
NewValue from CaseHistory where Date(CreatedDate,'DD-MM-YYYY')>='01-05-2018';

CaseTemp:
Load
Id,
Case_Type__c,
LastModifiedDate,
Origin,
Status,
CreatedDate as CaseCreatedDate
Resident Case1
;


CaseHistoryTemp:
Load
Id as CaseHistoryId,
CaseId as Id,
Field,
NewValue,
CreatedDate as CaseHistoryCreatedDate
Resident CaseHistory1
;

 

TemporaryTable:
Load
Id,
CaseCreatedDate as IntialDate
Resident
CaseTemp;

join (TemporaryTable)

Load
Id,
max(CaseHistoryCreatedDate) as FinalDate
Resident
CaseHistoryTemp
Where
Field = 'Subject'
and Match (NewValue,'URL LINK SENT', 'CSV FILE SENT', 'SELF INSTALLER', 'INSTALLER ACCEPTED')
Group By
Id
;

NWDData:
Load
Id,
NetWorkDays(IntialDate, FinalDate) as NWD
Resident
TemporaryTable
;
Drop Table TemporaryTable;