Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

v_ganchev
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!

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Sum of different currencies

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

AMOUNTS:

LOAD * INLINE [

Currency, Amount

EUR,33

USD,11

GBP,44

AUD,22

];

CURRXCHANGE:

LOAD * INLINE [

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...

View solution in original post

1 Reply
Highlighted
MVP
MVP

Re: Sum of different currencies

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

AMOUNTS:

LOAD * INLINE [

Currency, Amount

EUR,33

USD,11

GBP,44

AUD,22

];

CURRXCHANGE:

LOAD * INLINE [

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...

View solution in original post