topic where not exits function issue in QlikView

where not exits function issue

ravindraa — Wed, 13 Apr 2016 03:34:36 GMT

Hi all,

i struck one place give me some suggestion,

I have two tables one is Transaction table and other one is Rejection Table.

what are the Transaction's are matching with Rejection table Transaction's i am excluding those transaction's from Transaction table using where not Exits function.

but the thing is some transaction are repeating in other branches but those are not exclude.

please find the attached document . i created output sheet also.

kindly give any suggestion...

Thanks in advance...................................

Re: where not exits function issue

ravindraa — Wed, 13 Apr 2016 03:48:53 GMT

Hi Experts,

kindly look into it, give me any suggestion how to do this.

Thanks in advance...........................

Re: where not exits function issue

tresB — Wed, 13 Apr 2016 04:34:09 GMT

Try like:

Table1:

Load *,

Scheme&Plan&Brach&folino as Key

Inline [

Scheme,Plan,Brach,folino,Rbranch,Trno,Rtrno

CF,GP,HY01,123,HY01,1,2

TY,0TPlan,Delhi,108,Delhi,7,8

UB,0UPlan,Jaipur,109,Jaipur,9,10

];

Table2:

Load *

Inline [

Scheme,Plan,Brach,td Trno,folino,Trtype,ihno,AMOUNT

CF,GP,HY01,1,123,RED,222,100

CF,GP,HY01,2,123,REDR,222,100

AB,OAPlan,Mumbai,3,101,P,333,200

CF,Ocplan,Mumbai,4,102,R,444,500

GH,0GPlan,Chennai,5,107,Red,555,600

GH,0GPlan,Chennai,6,107,P,666,10

TY,0TPlan,Delhi,7,108,Red,999,30

TY,0TPlan,Delhi,8,108,REDR,800,40

UB,0UPlan,Jaipur,9,109,RED,900,50

UB,Uplan,Jaipur,10,109,REDR,1000,60

GH,0GPlan,Chennai,1,110,P,666,111111

TY,0TPlan,Kochi,2,111,Red,999,222222

] Where Not Exists(Key,Scheme&Plan&Brach&folino );

Drop Table Table1;

Re: where not exits function issue

ravindraa — Wed, 13 Apr 2016 05:58:40 GMT

Hi Tresesco,

Thank you very very very much .....................................

it is working for me