topic Re: Where exists in QlikView

Where exists

Fri, 29 Jun 2012 09:11:35 GMT

Hi all.

Could some one help me with a, I guess easy, where exists expression. I have to tables (Address and Contract) that are linked together and the keyfield is AdressID. There is only 10% of the contracts that have a address, which is correct. But I don't want to load all the addresses just the ones that have a contract.

Thanks!

Re: Where exists

Anonymous — Fri, 29 Jun 2012 09:13:05 GMT

Load

fieldA,

fieldB,

etc.

From Address

where exists(AdressID, AdressID);

Just make sure you load the Contract table first so you have the AdressID field there to refer to already.