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