Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to write not exists in script for 3 fields.

hi,

@How to write  not exists in  script for 3 fields.QlikTech Admin

For Ex : where Empid not exists (a,b)

exists accepts 2 fields so how to write it for 3 fields.

3 Replies
kumarnatarajan
Partner - Specialist
Partner - Specialist

Hi Pankaj,

We can use and condition see the below example

Ex: where not exists (Empid,Empid1) and not exists (Empid,Empid2)

israrkhan
Specialist II
Specialist II

Hi,

USE another Not Exist like below:

where Empid not exists (a,b) AND not exists (c)



MayilVahanan

Hi

May be try like this

where Empid not exists (a,b) and not exists(a,c);

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.