Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Tags (2)
2 Replies
sujeetsingh
Honored Contributor III

Re: Data Filter during Load

You can use Where Exsists() function while load.

Not applicable

Re: Data Filter during 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?