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

How to write not exists in script for 3 fields.

Wed, 04 Dec 2013 05:19:12 GMT

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 — Wed, 04 Dec 2013 05:31:32 GMT

Hi Pankaj,

We can use and condition see the below example

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

israrkhan — Wed, 04 Dec 2013 05:32:13 GMT

Hi,

USE another Not Exist like below:

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

MayilVahanan — Wed, 04 Dec 2013 05:33:41 GMT

May be try like this

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