Set the field of a table, as the join of two different fields of different tables

[#1]

Hello,

I have three charts like this:

I want to join the field 1 and the field 2 with the name Field 3, so the Qlikview automatically joins them. Is this possible?

[sgrice]

So you do not want to Actual change the underlying data structure. You just want to use in an expression.

Well set analysis can help

sum({<myMATCHFIELD1=myMATCHFIELD2>} SALES)

This would force  myMATCHFIELD1 to have the same list of vales has myMATCHFIELD2.

[ramoncova06]

which one of them do you want to join with table 3 ? you can not have both of them joining with table 3 because you would create a circular join