Currencies

[#1]

Hey guys,

I have a table in my database called rates. Where EUR is set to 1 and other currencies in the rate are compared to EUR (do you undestand my bad english?). For example: 1 euro = 1,12536 US-dollar.

So when im calculating turnover I take price*volume/exchangerate. Meaning I get everything to EUROS.

Whats an efficient way of doing this to other currencies now? Help much appreciated:)

[Gysbert_Wassenaar]

Perhaps this discussion helps: Re: Auto Currency convert‌

Or this one: Converting Currencies using a database currency table‌

If you need more help please post a small qlikview document with some data that illustrates the problem.

[Chanty4u]

chk dis

https://community.qlik.com/search.jspa?q=currencies

[Chanty4u]

chk dis

Re: Auto Currency convert

Creating a Date Interval from a Single Date

[#5]

Its to static im affraid, I work with stocks and currencies are important. In our database its mapped with date.

Any smart way when I just want to calculate the turnover from EUR to USD for example.