Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
v_ganchev
Contributor II
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
petter
Partner
Partner

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
petter
Partner
Partner

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