topic Re: Currency Conversion in QlikView https://community.qlik.com/t5/QlikView/Currency-Conversion/m-p/1332284#M825801 <HTML><HEAD></HEAD><BODY><P>Dear Prashant,</P><P>Thank you for ur suggestion.</P><P>Actually we dont have the conversion rate table.Is it possible to update daily with internet.</P><P></P><P></P><P>Regards,</P><P>Joshua.</P></BODY></HTML> Wed, 19 Jul 2017 06:11:25 GMT ajsjoshua 2017-07-19T06:11:25Z Currency Conversion https://community.qlik.com/t5/QlikView/Currency-Conversion/m-p/1332282#M825799 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I want to convert values in AED to USD based on the daily rates,</P><P>Pls suggest...</P><P></P><P>Regards,</P><P>Joshua.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Currency-Conversion/m-p/1332282#M825799 ajsjoshua 2020-11-25T16:16:04Z Re: Currency Conversion https://community.qlik.com/t5/QlikView/Currency-Conversion/m-p/1332283#M825800 <HTML><HEAD></HEAD><BODY><P>do you have any table or file where you maintain conversion rate????</P><P></P><P>If yes then write if condition</P><P>like if(currency_type='AED',value_field*conversion_rate,value_field)</P><P></P><P>Regards</P></BODY></HTML> Wed, 19 Jul 2017 06:06:29 GMT https://community.qlik.com/t5/QlikView/Currency-Conversion/m-p/1332283#M825800 PrashantSangle 2017-07-19T06:06:29Z Re: Currency Conversion https://community.qlik.com/t5/QlikView/Currency-Conversion/m-p/1332284#M825801 <HTML><HEAD></HEAD><BODY><P>Dear Prashant,</P><P>Thank you for ur suggestion.</P><P>Actually we dont have the conversion rate table.Is it possible to update daily with internet.</P><P></P><P></P><P>Regards,</P><P>Joshua.</P></BODY></HTML> Wed, 19 Jul 2017 06:11:25 GMT https://community.qlik.com/t5/QlikView/Currency-Conversion/m-p/1332284#M825801 ajsjoshua 2017-07-19T06:11:25Z Re: Currency Conversion https://community.qlik.com/t5/QlikView/Currency-Conversion/m-p/1332285#M825802 <HTML><HEAD></HEAD><BODY><P>chk below thread might help you</P><P></P><P></P><P><A href="https://community.qlik.com/thread/158992">Exchange Rate API</A>‌</P><P></P><P>Regards,</P></BODY></HTML> Wed, 19 Jul 2017 06:17:55 GMT https://community.qlik.com/t5/QlikView/Currency-Conversion/m-p/1332285#M825802 PrashantSangle 2017-07-19T06:17:55Z Re: Currency Conversion https://community.qlik.com/t5/QlikView/Currency-Conversion/m-p/1332286#M825803 <HTML><HEAD></HEAD><BODY><P>Hi Joshua,</P><P></P><P>Try:</P><P></P><P>[Conversion Rates]:</P><P>LOAD [Emirati Dirham], </P><P>&nbsp;&nbsp;&nbsp;&nbsp; [1.00 AED], </P><P>&nbsp;&nbsp;&nbsp;&nbsp; [inv. 1.00 AED]</P><P>FROM</P><P><SPAN>[</SPAN><A class="jive-link-external-small" href="http://www.x-rates.com/table/?from=AED&amp;amount=1" rel="nofollow" target="_blank">http://www.x-rates.com/table/?from=AED&amp;amount=1</A><SPAN>]</SPAN></P><P>(html, codepage is 1252, embedded labels, table is @1);</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Emirati Dirham</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>1.00 AED</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>inv. 1.00 AED</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">British Pound</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0.208914</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">4.786650</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Euro</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0.236136</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">4.234855</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Swiss Franc</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0.259769</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">3.849578</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">US Dollar</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0.272252</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">3.673071</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Australian Dollar</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0.343444</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2.911681</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Canadian Dollar</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0.344055</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2.906509</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Singapore Dollar</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0.372716</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2.683007</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Malaysian Ringgit</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1.166676</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0.857136</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Indian Rupee</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">17.516009</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0.057091</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Japanese Yen</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">30.513657</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0.032772</SPAN></TD></TR></TBODY></TABLE><P></P><P>Cheers</P><P></P><P>Andrew</P></BODY></HTML> Wed, 19 Jul 2017 07:40:54 GMT https://community.qlik.com/t5/QlikView/Currency-Conversion/m-p/1332286#M825803 effinty2112 2017-07-19T07:40:54Z