topic Re: where not exists and only get one line in QlikView

where not exists and only get one line

Mon, 26 Jan 2026 18:19:17 GMT

Hi I have incremental reload with where not exists syntax.

But I am getting only one record for the history.

I have been doing WHERE NOT EXISTS for many times, this is the first time I've seen this.

//today

LOAD Account,

Blalance,

PRCS_DTE

FROM

[..\03_QVD\Table_Incr.qvd]

(qvd);

//History

LOAD Account,

Blalance,

PRCS_DTE

FROM

[..\03_QVD\Table.qvd]

(qvd)

WHERE NOT EXISTS (PRCS_DTE)

;

Re: where not exists and only get one line

swuehl — Wed, 01 Feb 2017 21:04:56 GMT

That's because the symbol table will be updated as soon as the first record with a new PRCS_DTE value is loaded in (i.e. it is updated during the LOAD, not at the end of the statement).

Hence WHERE NOT EXISTS returns false for any following record with the same value.

Try

LOAD Account,

Blalance,

PRCS_DTE,

PRCS_DTE as PRCS_TODAY

FROM

[..\03_QVD\Table_Incr.qvd]

(qvd);

//History

LOAD Account,

Blalance,

PRCS_DTE

FROM

[..\03_QVD\Table.qvd]

(qvd)

WHERE NOT EXISTS (PRCS_TODAY, PRCS_DTE);

DROP FIELD PRCS_TODAY;

Re: where not exists and only get one line

Wed, 01 Feb 2017 21:51:08 GMT

Thank you Stefan, what does "symbol table" mean?

Re: where not exists and only get one line

swuehl — Wed, 01 Feb 2017 21:54:32 GMT

That's where the distinct field values are stored:

Symbol Tables and Bit-Stuffed Pointers

Re: where not exists and only get one line

Wed, 01 Feb 2017 22:00:30 GMT

Thank you very much! Tremendously helpful!

Re: where not exists and only get one line

johngouws — Sat, 26 Aug 2017 04:34:33 GMT

Hello Stefan,

I had a similar issue as Jessica today and I could adapt your solution to work for me.

Thank you, very much appreciated.

Re: where not exists and only get one line

marypapadopoulou — Wed, 06 May 2020 11:30:35 GMT

I created the new field but i still have the same problem.

I have a join statement in my first table, maybe this is the problem?