topic Re: Where filter from colA in table B in QlikView

Where filter from colA in table B

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

hi all,

i need to use filter in TableA for col1 from TableB. Means whatever the items is there in col1 tableB only those items should not appear in TableA. Please advise, thanks

TableA:

col1,

col2,

col3

from A

TableB:

col1,

col12,

Re: Where filter from colA in table B

Anonymous — Wed, 26 Jul 2017 03:04:29 GMT

Hi Srividhya,

Please share sample data and expected output.

Re: Where filter from colA in table B

Anonymous — Wed, 26 Jul 2017 03:11:54 GMT

Hi Mahesh

i have attached the sample in abv. plz refer. thanks

Re: Where filter from colA in table B

Anonymous — Wed, 26 Jul 2017 03:47:38 GMT

Hi Srividhya,

Please find the attachment. Hope it helps you.

Re: Where filter from colA in table B

Anonymous — Wed, 26 Jul 2017 03:49:20 GMT

Sorry, I am unable attach a file . please use below code

Table:

LOAD * INLINE [

T1, T2, T3

Apple, 10, 3

Mango, 30, 6

Orange, 56, 2

Grape, 23, 7

Kiwi, 65, 3

];

Table1:

LOAD * INLINE [

A1, A2, A3

Orange, 56, 2

Kiwi, 65, 3

];

test:

Load * ,1 as Demo Resident Table where not Exists(A1,T1);

drop Tables Table,Table1;

Re: Where filter from colA in table B

Anonymous — Wed, 26 Jul 2017 03:51:32 GMT

Check the attachment