Aggr of the same field values in 2 different tables where the fields are not linked, but same values

[Marius_]

Two tables are linked via site and contains the same field values. These to fields are not linked.

The idea is to summarize with aggregation the one table totals against the other table by using the field values that are the same in the two tables.

Aggregation on site (linked field) was successful but not with un-linked field

Please see Excel example and JPG for structure of model

[sunny_talwar]

May be create an island table for Group where you get all possible values from Table A and Table B and then use this

Sum(If(Group = TableAGroup, Value_A)

Sum(If(Group = TableBGroup, Value_B)

[Brett_Bleess]

I would also recommend reviewing the following Design Blog post, as it may be pertinent as well given your data model:

https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634

Regards,
Brett