topic Data Filter during Load in QlikView

Data Filter during Load

Thu, 13 Jun 2013 10:56:47 GMT

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

sujeetsingh — Thu, 13 Jun 2013 11:07:09 GMT

You can use Where Exsists() function while load.

Thu, 13 Jun 2013 11:25:13 GMT

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?