Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
guruprem
Partner
Partner

Exists Clause in Where

Hi,

These I found Exists clause is not working as per my understanding kindly advise.

1) LOAD * FROM xyz.QVD(qvd) Where Exists(COMP_CODE, 'ABC') is giving zero records. 

2) LOAD * FROM xyz.QVD(qvd) Where COMP_CODE='ABC' is giving very many records.

Best Regards

Guruprem

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Your above two statements are not going to produce same results.

 LOAD * FROM xyz.QVD(qvd) Where Exists(COMP_CODE, 'ABC')  - this statement would cause to:

   load COMP_CODE  'ABC' if that is already loaded (and exists) earlier. I would not go and explain more here, but ask you to check it here :Exists() in Qlik 

 

View solution in original post

2 Replies
tresesco
MVP
MVP

Your above two statements are not going to produce same results.

 LOAD * FROM xyz.QVD(qvd) Where Exists(COMP_CODE, 'ABC')  - this statement would cause to:

   load COMP_CODE  'ABC' if that is already loaded (and exists) earlier. I would not go and explain more here, but ask you to check it here :Exists() in Qlik 

 

View solution in original post

sunny_talwar

What exactly are you trying to do here? A brief introduction will help us point you in the right direction.