# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

New Contributor II

## Sum of different currencies

Hello.
Here is a example of my table.

Currency

Amount
Euro33
USD11
GBP44
AUD22

How it's possible to sum these different amounts as total in EURO.
Thanks!

Tags (7)
1 Solution

Accepted Solutions
Highlighted
MVP

## Re: Sum of different currencies

You can create a currency exchange table and then simply multiply by the exchange rate.

AMOUNTS:

Currency, Amount

EUR,33

USD,11

GBP,44

AUD,22

];

CURRXCHANGE:

Currency, xRate

EUR, 1

USD, 1.1

GBP, 1.3

AUD, 2.6

];

In a table in a sheet in your application you could have an expression like this:

Sum( Amount ) * xRate

and have the dimension: Currency.

This is an overly simplistic example but it is basically this approach...

Highlighted
MVP

## Re: Sum of different currencies

You can create a currency exchange table and then simply multiply by the exchange rate.

AMOUNTS:

Currency, Amount

EUR,33

USD,11

GBP,44

AUD,22

];

CURRXCHANGE:

Currency, xRate

EUR, 1

USD, 1.1

GBP, 1.3

AUD, 2.6

];

In a table in a sheet in your application you could have an expression like this:

Sum( Amount ) * xRate

and have the dimension: Currency.

This is an overly simplistic example but it is basically this approach...