Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Luffy1994
Contributor II
Contributor II

Where exist not working

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

 

 

Labels (2)
1 Solution

Accepted Solutions
Or
MVP
MVP

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.

View solution in original post

2 Replies
Or
MVP
MVP

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
Not applicable

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)