Discussion Board for collaboration on QlikView Scripting.
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
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)
ApplyMap('MAPTABLE',FIELD1) AS VisitHubGoLiveDate
The two tables are joined based on the HubReference
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
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?