topic Re: Currency in QlikView

Currency

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Currency

qlikview979 — Wed, 28 Sep 2016 06:47:05 GMT

Hi Experts,

Is it Possible in qlikview

stalwar1‌swuehl‌jagan‌dvqlikview‌

Re: Currency

tresB — Wed, 28 Sep 2016 06:48:22 GMT

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

Re: Currency

qlikview979 — Wed, 28 Sep 2016 06:54:49 GMT

Hi Bro,

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

Re: Currency

qlikview979 — Wed, 28 Sep 2016 06:58:37 GMT

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

Re: Currency

trdandamudi — Wed, 28 Sep 2016 07:00:43 GMT

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

Re: Currency

trdandamudi — Wed, 28 Sep 2016 07:08:07 GMT

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

Re: Currency

qlikview979 — Wed, 28 Sep 2016 07:13:05 GMT

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]

Re: Currency

trdandamudi — Wed, 28 Sep 2016 07:42:22 GMT

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

Re: Currency

qlikview979 — Wed, 28 Sep 2016 08:02:29 GMT

Here how can i change dynamic values dynamically Every day .

Re: Currency

tresB — Wed, 28 Sep 2016 08:13:34 GMT

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

Re: Currency

Colin-Albert — Wed, 28 Sep 2016 08:20:53 GMT

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.

Re: Currency

trdandamudi — Wed, 28 Sep 2016 08:22:31 GMT

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.

Re: Currency

Anonymous — Wed, 28 Sep 2016 11:19:01 GMT

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)

Re: Currency

qlikview979 — Wed, 28 Sep 2016 11:38:15 GMT

Hi rgv,

Here Rate is static or Dynamic values

Rate

0.015045

0.013418

0.019630

0.100383

Regards,

Mahesh

Re: Currency

Anonymous — Wed, 28 Sep 2016 11:43:02 GMT

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

For your explaination i had taken rate as static.