Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Re: Incremental load

Thanks a lor Rob! This worked

I didn't know that's how not exists behaves, I really appreciate your explanation.


Oscar Marquez


Re: Incremental load

Something more on the exists function on the same lines:

If you want to do the distinct load on a field we can use:

Load A, B, C, from Employees.csv where not exists (A);

This is equivalent to performing a distinct load on field A.

Read about this in the help file for exists function it will help you in clearing your concepts about exists  function, also do understand on how Qlik stores data internally in form of bit stuffed pointers.