topic Re: Regarding Exist() function and it's functionality in QlikView

Regarding Exist() function and it's functionality

Wed, 03 Dec 2014 06:24:10 GMT

HI,

I need a explanation on exist() function. I had searched and saw the exist function. But am not getting clear view on this. So, can you please clearly explain this.

It would be very helpful to me.

Regards,

Ramana.

Re: Regarding Exist() function and it's functionality

jagadeesh_diamo — Wed, 03 Dec 2014 06:35:12 GMT

Can you tell whether you are looking for exit statement or function?

Re: Regarding Exist() function and it's functionality

Wed, 03 Dec 2014 06:59:29 GMT

HI Sir,

I need exist() function

where exist() and where not exist()...I need a clear view on this..

Re: Regarding Exist() function and it's functionality

SunilChauhan — Wed, 03 Dec 2014 07:02:19 GMT

below for where Exists

Table1:

Load * inline [

column1

];

Table2:

Load * inline [

column2

] where Exists(column1,column2);

drop table Table1;

Re: Regarding Exist() function and it's functionality

SunilChauhan — Wed, 03 Dec 2014 07:07:21 GMT

below code for not exist

Table1:

Load * inline [

column1

];

Table2:

Load * inline [

column2

] where not Exists(column1,column2);

drop table Table1;

let me know if any Q's

Re: Regarding Exist() function and it's functionality

its_anandrjs — Wed, 03 Dec 2014 07:12:23 GMT

Hi,

Assume this example for Exists

LOAD * Inline [

ITEM,classes

14 ];

LOAD * Inline [

ITEMID,class

12 ] Where Exists(ITEM,ITEMID);

Means in ItemId you get only that id which match in the Item field

You Get in

And for Where NOT Exists

LOAD * Inline [

ITEM,classes

14 ];

LOAD * Inline [

ITEMID,class

12 ] Where Not Exists(ITEM,ITEMID);

And difference you get

Means in ItemId you get only that id which not match in the Item field

Regards

Anand

Re: Regarding Exist() function and it's functionality

SunilChauhan — Wed, 03 Dec 2014 07:18:37 GMT

@ Anand,

in both cases of yours its need to drop first table then only we could find record which exists and not exists from first table

other wise it will give you all record in first table and existing record from second and

all record in first table and not existing record from second

hope this make sense

Re: Regarding Exist() function and it's functionality

Wed, 03 Dec 2014 07:22:03 GMT

Thank you now i got clarity....

Re: Regarding Exist() function and it's functionality

SunilChauhan — Wed, 03 Dec 2014 07:25:25 GMT

Mark it correct or helpful for suitable answer .so that post is closed.

Re: Regarding Exist() function and it's functionality

its_anandrjs — Wed, 03 Dec 2014 07:27:24 GMT

Sunil,

Thats right intentionally i not drop the table for get values of the first and then second table to get values. But for final result we need to drop the Table one at the end of the table load for both case like.

T1:

LOAD * Inline [

ITEM,classes

14 ];

T2:

LOAD * Inline [

ITEMID,class

12 ] Where Exists(ITEM,ITEMID);

Drop Table T1;

Regards

Anand

Re: Regarding Exist() function and it's functionality

SunilChauhan — Wed, 03 Dec 2014 07:30:55 GMT

thanks Anand .i

Re: Regarding Exist() function and it's functionality

its_anandrjs — Fri, 05 Dec 2014 20:07:46 GMT

Hi Ramana,

Close the thread with appropriate answers to members.

Regards

Anand

Re: Regarding Exist() function and it's functionality

Anonymous — Fri, 05 Dec 2014 20:27:36 GMT

Hi,

See below link:

The exists issue

Regards

Neetha

Re: Regarding Exist() function and it's functionality

Sat, 06 Dec 2014 04:54:47 GMT

HI Sir,

Sorry sir i don't know how to close the thread. Now i will do that sir...

Please don't mind me..

Thank you,

Ramana.