Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am struggling with the following senario, any help would be much appreciated.
I would like to filter visits that are loaded into Qlikview based on the VisitHubGoLiveDate
E.g.
1. Only Load visits for site 1 where the VisitStartDate > = VisitHubGoLiveDate (VisitHubGoLiveDate = 01/01/2013)
2. Only Load visits for site 2 where the VisitStartDate > = VisitHubGoLiveDate (VisitHubGoLiveDate = 01/04/2013)
Visits:
Load
HubReference,
VisitStartDate,
ApplyMap('MAPTABLE',FIELD1) AS VisitHubGoLiveDate
;
Select *
FROM dbase.Visits;
The two tables are joined based on the HubReference
Hub:
Load
HubReference,
GoLiveDate
;
Select *
FROM dbase.Hub;
Thanks
Martyn
You can use Where Exsists() function while load.
I have attempted to add the wehere exists function but I am not sure If I am scripting it correctly
I have added the following to the script
SQL
SELECT *
FROM dbase.Visits (nolock)
where Exists (VisitStartDate > = VisitHubGoLiveDate);
Does this still work even if the Field VisitHubGoLiveDate is not part of the source table?