Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

currency convert

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.

4 Replies
yduval75
Partner
Partner

Hello

Link your dollar value to your calendar

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

MK_QSL
MVP
MVP

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)

michielvandegoo
Specialist
Specialist

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

lcz
Employee
Employee

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.