7 Replies Latest reply: Aug 12, 2015 11:14 AM by Mark Graham RSS

    Incremental Load

    Mark Graham

      Hi all,

       

      I'm a beginner in QlikView.

       

      One of my QlikView application taking couple of hours to load as the data is about past 2 years.

       

      I wanna use Incremental load such that, first load will fetch all the records, and for the rest of the loads - it just brings the data which is newly loaded.

       

      I do have  a Date field.

       

      For eg: I have all the data till 8/9/2015 and i wanna concatenate the data from 8/10/2015 to the existing data.

       

      I was struggling to get the proper expression.

      Can someone help here.

       

       

      Load * from xyz.qvd .

       

      Incremental setup:

      Load * from xyz.qvd Where Date>=8/9/2015.

      But i wanna load only values which were not present.