Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
Contributor 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.

Regards,

Oscar Marquez

Highlighted
Contributor

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.