Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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])
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.