topic Currencies in QlikView https://community.qlik.com/t5/QlikView/Currencies/m-p/1031566#M348230 <HTML><HEAD></HEAD><BODY><P>Hey guys,</P><P></P><P class="vk_gy vk_sh">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.</P><P class="vk_gy vk_sh"></P><P class="vk_gy vk_sh">So when im calculating turnover I take price*volume/exchangerate. Meaning I get everything to EUROS.</P><P class="vk_gy vk_sh"></P><P class="vk_gy vk_sh">Whats an efficient way of doing this to other currencies now? Help much appreciated:)</P></BODY></HTML> Thu, 14 Apr 2016 08:23:17 GMT 2016-04-14T08:23:17Z Currencies https://community.qlik.com/t5/QlikView/Currencies/m-p/1031566#M348230 <HTML><HEAD></HEAD><BODY><P>Hey guys,</P><P></P><P class="vk_gy vk_sh">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.</P><P class="vk_gy vk_sh"></P><P class="vk_gy vk_sh">So when im calculating turnover I take price*volume/exchangerate. Meaning I get everything to EUROS.</P><P class="vk_gy vk_sh"></P><P class="vk_gy vk_sh">Whats an efficient way of doing this to other currencies now? Help much appreciated:)</P></BODY></HTML> Thu, 14 Apr 2016 08:23:17 GMT https://community.qlik.com/t5/QlikView/Currencies/m-p/1031566#M348230 2016-04-14T08:23:17Z Re: Currencies https://community.qlik.com/t5/QlikView/Currencies/m-p/1031567#M348231 <HTML><HEAD></HEAD><BODY><P>Perhaps this discussion helps: <A href="https://community.qlik.com/message/994296">Re: Auto Currency convert</A>‌</P><P>Or this one: <A href="https://community.qlik.com/message/66521">Converting Currencies using a database currency table</A>‌</P><P></P><P>If you need more help please post a small qlikview document with some data that illustrates the problem.</P></BODY></HTML> Thu, 14 Apr 2016 08:24:54 GMT https://community.qlik.com/t5/QlikView/Currencies/m-p/1031567#M348231 Gysbert_Wassenaar 2016-04-14T08:24:54Z Re: Currencies https://community.qlik.com/t5/QlikView/Currencies/m-p/1031568#M348232 <HTML><HEAD></HEAD><BODY><P>chk dis</P><P></P><P><A href="https://community.qlik.com/t5/forums/searchpage/tab/message?q=currencies">https://community.qlik.com/search.jspa?q=currencies</A></P></BODY></HTML> Thu, 14 Apr 2016 08:25:23 GMT https://community.qlik.com/t5/QlikView/Currencies/m-p/1031568#M348232 Chanty4u 2016-04-14T08:25:23Z Re: Currencies https://community.qlik.com/t5/QlikView/Currencies/m-p/1031569#M348233 <HTML><HEAD></HEAD><BODY><P>chk dis</P><P><A href="https://community.qlik.com/message/994296">Re: Auto Currency convert</A></P><P><A href="https://community.qlik.com/qlik-blogpost/2960">Creating a Date Interval from a Single Date</A></P></BODY></HTML> Thu, 14 Apr 2016 08:26:21 GMT https://community.qlik.com/t5/QlikView/Currencies/m-p/1031569#M348233 Chanty4u 2016-04-14T08:26:21Z Re: Currencies https://community.qlik.com/t5/QlikView/Currencies/m-p/1031570#M348234 <HTML><HEAD></HEAD><BODY><P>Its to static im affraid, I work with stocks and currencies are important. In our database its mapped with date.</P><P>Any smart way when I just want to calculate the turnover from EUR to USD for example.</P></BODY></HTML> Thu, 14 Apr 2016 08:31:49 GMT https://community.qlik.com/t5/QlikView/Currencies/m-p/1031570#M348234 2016-04-14T08:31:49Z