Combine various Currencies

johngouws — Mon, 11 Sep 2017 03:44:41 GMT

Good Morning.

I have a need to consolidate currencies from various countries. The currency and exchange rate for each Country is different. The data source has each day's exchange rate I am able to use. Among the fields available are:

County,

Date,

Exchange_Rate - (associated to the Date),

Currency_Code - (Local, USD, EURO)

Revenue.

When I select one Country only I get a Total for the expression but when there are multiple Countries selected, I have to select Total Mode "sum of rows" to get a Total. I would think that this is something to do with AGGR, but I cannot get it correct. The expression I am using is:

"AGGR(sum(Revenue)/Exchange_Rate,County,Date)"

I have also tried:

"AGGR(sum(Revenue)/Exchange_Rate,County,Date,Currency_Code )"

Please can someone assist with the reason for this.

Thanking you.

topic Combine various Currencies in QlikView

Combine various Currencies