Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

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:

ExternalExt.ValueInternalInt.Value
A100A'80
B200B'100
C50--------

Object2:

ExternalExt. Value
D100
E300
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.

2 Replies
MVP
MVP

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

if you have 2 tables

I:

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])

Not applicable

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

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.

Community Browser