topic How to exclude data in QlikView

How to exclude data

Wed, 12 Jan 2011 02:52:34 GMT

Hi,

I have two tables:

MainTable:

MemberId

ExcludeTable:

MemberId

How to use script to exclude memberid 1?

I just want to get 2,3

Thanks.

How to exclude data

pover — Wed, 12 Jan 2011 03:13:51 GMT

Use the exists() function.

ExcludeTable:

Load MemberId as MemberId_Exclude
From ExcludeTable;

MainTable:

Load MemberId
From MainTable
Where not exists(MemberId, MemberId_Exclude);

Regards.

How to exclude data

Wed, 12 Jan 2011 03:38:35 GMT

Hi,

But I use SQL not load, how can I use Exist function?

SQL select MemberId as ExcludeMemberId
FROM Test.dbo.ExcludeMember;

SQL select MemberId
FROM Test.dbo.MemberId
;

How to exclude data

Wed, 12 Jan 2011 03:43:23 GMT

you can use this as your basis:

LOAD *,

if(Exists(Field1,Field2),Field2)

Resident TableName;

How to exclude data

Anonymous — Wed, 12 Jan 2011 03:46:06 GMT

Nothing prevents you from using preceding load:


ExcludeTable:
SQL select MemberId as ExcludeMemberId
FROM Test.dbo.ExcludeMember;
MainTable:
LOAD MemberId
Where not exists(MemberId, MemberId_Exclude);
SQL select MemberId
FROM Test.dbo.MemberId;

How to exclude data

Wed, 12 Jan 2011 04:03:25 GMT

Sorry, what's the meaning of ' MemberId_Exclude'?

How to exclude data

Wed, 12 Jan 2011 04:08:12 GMT

thats the alias of the MemberId you loaded from

Test.dbo.ExcludeMember