Currency

[#1]

Hi,

I have a requirement , i need to show different currency formats in my application (AUS,USD,CAD,EUR,GBP) with given exchange rate (AUD=1.0908 ,CAD=1.0187 etc). If i Qlik on USD currency the amount (one of the table column)needs to multiply with given exchange rate and disply the exact convesion amount. Any help will be highly appriciated.

Thanks in Advance,

Daram

[Anonymous]

You can create a logical island in your data model, a table with currency name and rate. On the front end, create a list box with currency names (AUS, USD, ...) and allow only one selected value. In the charts, use expressions with rates, like:
sum(Amount)*Rate

[#3]

Hello Daram,

Did you find out how to solve this. I have similar situation and I am desperate about the answer.

Can you please respond ASAP to my below email. Appreciate your help in this.

Thanks

Chaitanya

chaitanyakadiyala@gmail.com

[#4]

Michael's answer will work a treat... create a table with one column representiing the currency, the other the rate

CURR RATE

USD 1.63

EUR 1.13

etc...

And then put a list box with Always 1 value selected ticked in the app using the the field CURR

In you expressions multiple the Value (which would be in GBP in this example) by RATE

e.g. = SUM(Value) * RATE

As people click from one CURR to another, the rate will change and your expressions will reflect that...