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

[qlikview979]

Hi Experts,

Is it Possible in qlikview

stalwar1‌swuehl‌jagan‌dvqlikview‌

[tresesco]

You have to incorporate a ConversionRate column in the table and then you can achieve it as shown in the attached sample.

[qlikview979]

Hi Bro,

I have Doubt here Conversion Rate is Static or Dynamic for example USA is 67 its static right.

[qlikview979]

if USA conversion rate became 65 how can i calculate that

some times Dollar value will become 65 or 67 or 63   how can i calculate Dynamically

Regards,

Mahesh

[trdandamudi]

If you don't refresh your conversion rates on Daily/Weekly/Monthly then it is static. Because the USD rate changes every day. Hope this helps...

[trdandamudi]

You need to get a daily feed and refresh it.... It will be something like below:

ID,COUNTRY,AMOUNT,CURRENCY

1,INDIA,100,INR

2,USA,100,USD

3,GERMANY,100,DEM

4,AUSTRALIA.100,AUD

5,CHINA,100,CNY

CURRENCY,RATE

INR,1

USD,65

DEM,90

AUD,70

CNY,80

[qlikview979]

Hi Thirumala  i got  this conversion rate from tresesco    it is Dynamic Right

Load * Inline [

D,COUNTRY,Value, ConversionRate

1,INDIA,100, 1

2,USA,100, 67

3,GERMANY,100, 90

4,AUSTRALIA,100, 40

5,CHINA,100, 50]

[trdandamudi]

I think few of them are made up rates, so all of them are not dynamic... As of today the rates are as below:

D,COUNTRY,Value, ConversionRate

1,INDIA,100, 1

2,USA,100, 67

3,GERMANY,100, 38

4,AUSTRALIA,100, 51

5,CHINA,100, 10]

Hope this helps....

[qlikview979]

Hi

Here  how can i change dynamic values   dynamically  Every day .