topic NOT Exists (function behavior) in QlikView

NOT Exists (function behavior)

pablolabbe — Tue, 02 Feb 2010 16:28:22 GMT

I attached a sample application to test the strange behavior when using not exists against a previous loaded field with same fieldname and different fieldname compared.

Someone has an explanation ?

NOT Exists (function behavior)

lironbaram — Tue, 02 Feb 2010 19:25:20 GMT

the problem is that while evluating the value on the field dt_table2

in the start you your exists list contain one value 01/01/2009 ,

so the first rows don't load because the filed in the date_filter table

but after the first row with the vakue 02/01/2009 is loaded from table 2

now the exsits list is containing two values 01/01/2009,02/01/2009

so all the dont load either

it because your filter field and traget field have the same name.

NOT Exists (function behavior)

lironbaram — Tue, 02 Feb 2010 19:25:36 GMT

the problem is that while evluating the value on the field dt_table2

in the start you your exists list contain one value 01/01/2009 ,

so the first rows don't load because the filed in the date_filter table

but after the first row with the value 02/01/2009 is loaded from table 2

now the exsits list is containing two values 01/01/2009,02/01/2009

so all the dont load either

it because your filter field and traget field have the same name.