Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Incremental load to replace last month

Hi All,

i have built an incremental load that uses the following simple logic:

Tbl: Load data from .csv for latest month, create date key '%keyDate'

Set vLatestDate = Peek(%keyDate)

concatenate (Tbl)

Load data from historic.qvd where date key <> vLatestDate

Where I am struggling is - I would like to replace the <>vLatestDate above with a 'NOT EXISTS' clause so that it can load in an optimized fashion... but I can't get the logic to work!

Any help gratefully received! Thanks.

1 Reply
Highlighted
Specialist
Specialist

Can anybody help with this?