2 Replies Latest reply: Jun 13, 2013 7:25 AM by Martyn Alford RSS

    Data Filter during Load

      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