Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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()