Discussion Board for collaboration on QlikView Layout & Visualizations.
The data is in separate silos. Silos must not be connected by key field.
How to make a straight table where dimension is a common field in both silos (different names) and expressions come from both silos.
Name sum(AmountA) sum(AmountB)
Tom 20 4
Bob 25 7
Tim 30 3
Jim 90 4
Please see the attachment where I started to study this issue.
I can't see any good reason that the best solution wouldn't be to solve for this somehow in your data model.
Nonetheless, here's a sample where I used a synthetic dimension funtion (ValueList) to accomplish what I believe is what you are after.