Data joining in QlikView

[Anonymous]

Hi All

I am facing data joining issue.Initially my data has two tables as below:

I used applymap for Region and country columns so as to get full names,but still I am getting table as above.I need something which looks like:

Please help me.....

[Anonymous]

Issue was resolved I am using field itself as an expression,now I understood that we have to give it as sum(amount)