Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
PrajS
Contributor III
Contributor III

What is the equivalent operator of NOT IN in Qlik sense script

Hi ,

Need help!

I am trying to write below query in my dataload editor page of app

 

Select  * from table1

where c1  NOT IN (select c1 from table2); 

 

But not working 

what do I replace NOT IN with?

 

Thank you 

1 Reply
Vegar
MVP
MVP

Take a look at the NOT EXISTS() functionality. 

 

It is not 100% identical to NOT IN, but you will be able to do the same using not Exists()