Calculate multiple currencies into USD's

[qlikmpate0]

I would like to convert the local currency amount into USD's currency amount so  I get the following table

total Amount in local currency, total amount in USD's   

I have the following tables loaded.

table exchange rates

currency  exchangerates

USD, 1.23

GBP, 1.01

EUR, 1.48

table 2

UNIT_PRICE * QUANTITY    as [Amount] - in local currency

table 3

Currency code   - currency

any help appreciated. Thanks in advance.

[Gysbert_Wassenaar]

Try searching first: https://community.qlik.com/search.jspa?q=currency

[qlikmpate0]

Thanks I did, but wasn't successful, will try again, thanks and sorry.

[Gysbert_Wassenaar]

No problem. Feel free to ask again if you need more help. If you do please provide more information about your document, what you try to achieve and what you've tried already. A qlikview document that demonstrates the problem will be helpful.