topic currency convert in QlikView

currency convert

Thu, 10 Apr 2014 08:50:46 GMT

Hi, please some body help.

1) i have data like sales/billing...etc in the firm of Rupees But i want in Dollars. How I can convert?

2) The dollar value changes regularly how i can maintain or converting rupees to dollar regularly.

Please some one help me.

Re: currency convert

yduval75 — Thu, 10 Apr 2014 08:55:26 GMT

Hello

Link your dollar value to your calendar

and in your expression Sum (sales) / Sum (salesBilling) * CurrencyField

Re: currency convert

MK_QSL — Thu, 10 Apr 2014 09:00:07 GMT

You definitely have Date in your Sales/Billing Data... Create a master calendar for these Dates.

Now Create a table with Date and Rs vs USD rate.

Make sure that the name of Date Field should be same for both..

now you can use...

SUM(Quantity*Amount/USDRate)

Re: currency convert

Michiel_QV_Fan — Thu, 10 Apr 2014 09:12:40 GMT

For changing exchange rates you'd better off with an interval match, if, the exchange rate for the historical records stays the same.

Load the exchange rate for the corresponding period with interval match in your fact table. Calculate in a new column the Rs amount with the exchange rate to USD.

Create a group of expression, 1 with sum Rs and 1 with sum USD.

Again: only if the historical exchange rate has to be kept.

For interval match examples go to:http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/25/creating-intervals-from-change-dates

Re: currency convert

Luis_Cortizo — Thu, 10 Apr 2014 09:28:44 GMT

Hi,

From my point of view, two different problems here:

- Implementation of the currency exchange: You can find many examples on how to implement it here on the community, but my recommendation would be to download this demo and take a look on how it has been implemented:

Qlik Demos: See QlikView in Action | Demo.Qlik.Com

More examples:

Multi-Currency

https://www.youtube.com/watch?v=fyb9GQClGTo

- Datasource for currency exchange. On a real life scenario currency changes every day so the closer you want to get to a real life exchange the more updates you need on the data source. If your server is connected to the Internet you can read the currency exchange from any of the webpages created for this. This would be an example of loading information from xe.com

Currency:

CrossTable([Currency Exchange], Amount)

LOAD @1 as Currency,

@2 as USD,

@3 as EUR,

@4 as GBP,

@5 as INR,

@6 as AUD,

@7 as CAD,

@8 as ZAR,

@9 as NZD,

@10 as JPY

FROM

[http://www.xe.com/?c=INR]

(html, codepage is 1252, no labels, table is @1, filters(

Remove(Row, Pos(Top, 9)),

Remove(Row, Pos(Top, 7)),

Remove(Row, Pos(Top, 5)),

Remove(Row, Pos(Top, 3)),

Remove(Row, Pos(Top, 1)),

Remove(Col, Pos(Top, 1))

));

(just an example you can use any webpage you fancy).

If your server is not connected to the internet, you will need to update manually the datasource (excel, QVD, database) and then reload the QlikView document.

Hope it helps.

Best regards.