topic Re: Filter by date in script in QlikView

Filter by date in script

Wed, 11 Jun 2014 16:53:10 GMT

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

Re: Filter by date in script

ashfaq_haseeb — Wed, 11 Jun 2014 16:57:25 GMT

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

Re: Filter by date in script

Anonymous — Wed, 11 Jun 2014 17:10:26 GMT

Date "likes" to be in the single quotes:

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

Re: Filter by date in script

Wed, 11 Jun 2014 19:14:14 GMT

Thanks a lot!!!

Re: Filter by date in script

Wed, 11 Jun 2014 19:14:29 GMT

Thanks a lot!!!

Re: Filter by date in script

murugesh — Thu, 04 Jul 2019 14:54:44 GMT

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;