Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

2 Replies
sujeetsingh
Master III
Master III

You can use Where Exsists() function while load.

Not applicable
Author

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?