topic Exclude records in an object that are already displayed in another object in QlikView

Exclude records in an object that are already displayed in another object

Tue, 12 Jan 2016 10:51:34 GMT

Hello,

I have a doubt and I want to know if this is possible and please forward me to another discussion or possible give me a solution (I can not find anything related to this)

I'm creating two objects that both show different information (using set analysis), yet I have one condition that I can't do.

I will explain better with an example:

Object1:

External	Ext.Value	Internal	Int.Value
A	100	A'	80
B	200	B'	100
C	50	----	----

Object2:

External	Ext. Value
D	100
E	300
A'	80
B'	100

As shown above is how it is now.

What I want is to exclude from object2 the lines A' and B'. Because this documents are displayed in object1 in the Internal column.

I just want to display in object2 the internal documents that are not related to an External Document.

I know it's possible to exclude values for example using this in the calculated dimension:

=aggr(only({<Type = {'*'}-{'Credit','Debit'}>} Type),Type)

But as this are two different fields, I am not being able to pull this.

Thanks very much.

Re: Exclude records in an object that are already displayed in another object

maxgro — Tue, 12 Jan 2016 12:23:10 GMT

if you have 2 tables

load * inline [

External, Ext.Value, Internal, Int.Value

A, 100, A', 80

B, 200, B', 100

C, 50, ----, ----

];

II:

load * Inline [

Internal, Int. Value

D, 100

E, 300

A', 80

B', 100

];

you can try in a chart with Internal as dimension and this expression

sum({$ <Internal={"=count(External)=0"}>} [Int. Value])

Re: Exclude records in an object that are already displayed in another object

Tue, 12 Jan 2016 14:33:55 GMT

Hello,

thanks for your quick reply.

I'm sorry I did not explain that this data is all in the same table.

I just separate it into two objects using calculated dimensions like this:

=aggr(only({<Organization = {'123'}>} Organization),Organization)

There are more columns in this objects. I just showed this because I think these are the only ones that matter.