Currency

[qlikview979]

Hi Experts,

I need your Help I have table like

ID,COUNTRY,CURRENCY

1,INDIA,100

2,USA

3,GERMANY

4,AUSTRALIA

5,CHINA

Here if i  click on INDIA it will show 100

for example if i click on USA what is the value of 100 in USA currency and

if i click on GERMANY what is the value of 100 in GERMANY Currency

I want like this rest of the country's also

is it possible in qlikview.

Regards,

Mahesh

[tresesco]

You can maintain an excel or refer any website that shows dynamic rates (if any).

[Colin-Albert]

Have a look at this post matching currency exchange rate

Or create a table with the currency, dates and exchange rates and look at the Extended Interval Match function.

[trdandamudi]

There are couple of ways as below:

1) Get a daily or weekly feed file from your finance group

2) Get the latest rates from the web and update them in a excel file and use that file to load the rates.

Note: You don't need a incremental load for rates.

[Anonymous]

Hi Mahesh ,

try this

Load * inline

[

ID,COUNTRY,CURRENCY

1,INDIA,INR

2,USA,US$

3,GERMANY,GRE

4,AUSTRALIA,AU$

5,CHINA,CHY

];

XRate:

Load * inline

[

ID,Rate

1,1

2,0.015045

3,0.013418

4,0.019630

5,0.100383

];

In text box use 100*Rate .

select the country from list box ,so respective currency conversion will be appeared in text box .

100 is basecurrency (INR)

[qlikview979]

Hi rgv,

Here Rate is static or Dynamic values

Rate

0.015045

0.013418

0.019630

0.100383

Regards,

Mahesh

[Anonymous]

The above Rate is static.To get dynamic dates use webservice .

For your explaination i had taken rate as static.