topic Re: Currency convertion in QlikView https://community.qlik.com/t5/QlikView/Currency-convertion/m-p/1246215#M864988 <HTML><HEAD></HEAD><BODY><P>you could create a table with currency and respective conversion rate that you want to apply to your amount.</P><P>The moment end user selects the Currency the rate would be applied to the amount field.</P><P>You also need to keep the amount in a native currency rate so that the conversion will be applied based on that. </P><P>Your Amount expression would have like Sum(Amount)*Rate.</P></BODY></HTML> Thu, 29 Dec 2016 16:14:41 GMT sudeepkm 2016-12-29T16:14:41Z Currency convertion https://community.qlik.com/t5/QlikView/Currency-convertion/m-p/1246213#M864986 <HTML><HEAD></HEAD><BODY><P>I have a problem with the currency exchange guy I have two fields in the table one is of amount and the other is of currency type, what I can not do is that if the currency type is equal to 1 I convert all the amounts into dollars Of the field amount and if the exchange rate is equal to 2 m and I convert all the amounts in euros of the amount field.</P><P>I do not know if you let me understand to get help about it from now on thanks for the collaboration.</P><P>Ie as shown in the image select the type of currency and I convert all the amounts</P><P><IMG alt="moneda.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/147883_moneda.jpg" style="height: auto;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Currency-convertion/m-p/1246213#M864986 Anonymous 2020-11-25T16:16:04Z Re: Currency convertion https://community.qlik.com/t5/QlikView/Currency-convertion/m-p/1246214#M864987 <HTML><HEAD></HEAD><BODY><P>This link may help you </P><P><A href="https://community.qlikview.com/thread/16376" style="font-size: 10pt;" title="https://community.qlikview.com/thread/16376">https://community.qlikview.com/thread/16376</A></P></BODY></HTML> Thu, 29 Dec 2016 16:11:26 GMT https://community.qlik.com/t5/QlikView/Currency-convertion/m-p/1246214#M864987 sangeess21 2016-12-29T16:11:26Z Re: Currency convertion https://community.qlik.com/t5/QlikView/Currency-convertion/m-p/1246215#M864988 <HTML><HEAD></HEAD><BODY><P>you could create a table with currency and respective conversion rate that you want to apply to your amount.</P><P>The moment end user selects the Currency the rate would be applied to the amount field.</P><P>You also need to keep the amount in a native currency rate so that the conversion will be applied based on that. </P><P>Your Amount expression would have like Sum(Amount)*Rate.</P></BODY></HTML> Thu, 29 Dec 2016 16:14:41 GMT https://community.qlik.com/t5/QlikView/Currency-convertion/m-p/1246215#M864988 sudeepkm 2016-12-29T16:14:41Z