Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Luffy1994
Contributor
Contributor

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.

JohnInSDDupe
Creator
Creator

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)