topic Currency in QlikView

Currency

Tue, 21 Sep 2010 15:57:28 GMT

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

Currency

Anonymous — Tue, 21 Sep 2010 16:40:59 GMT

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

Currency

Wed, 06 Apr 2011 20:43:28 GMT

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

Currency

Wed, 06 Apr 2011 21:56:50 GMT

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