Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
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
Partner
Partner

Re: How to write not exists in script for 3 fields.

Hi Pankaj,

We can use and condition see the below example

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

israrkhan
Valued Contributor II

Re: How to write not exists in script for 3 fields.

Hi,

USE another Not Exist like below:

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



Re: How to write not exists in script for 3 fields.

Hi

May be try like this

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