How to write not exists in script for 3 fields.

[#1]

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.

[kumarnatarajan]

Hi Pankaj,

We can use and condition see the below example

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

[israrkhan]

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);