topic Where exist not working in QlikView

Where exist not working

Luffy1994 — Wed, 06 Jul 2022 08:36:03 GMT

Hi All,

i am not able to understand the why script is not loading in optimized way, below is my sciprt

temp_id:
LOAD * INLINE [
appid
0
];

load Id

from abc.qvd

where exist (appid);

where appid is present in abc.qvd

the script is filtering the data but not in optimized way

Or — Wed, 06 Jul 2022 08:41:56 GMT

Load Id, appid

from qbc.qvd

Where exists(appid);

You need the exists() field in your load if you want an optimized load, I believe.

Anonymous — Wed, 06 Jul 2022 15:48:31 GMT

Does appid exist in the qbc.qvd, or does id = appid? If the latter then the clause might be

where exists(appid,id).

HTH.

John

(aka jpohncaqc)