topic Transactions in different currencies in QlikView https://community.qlik.com/t5/QlikView/Transactions-in-different-currencies/m-p/169729#M40421 <HTML><HEAD></HEAD><BODY><P>You can use an expression that looks something like this:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />=Currency&amp;' '&amp;[Default Value]*CurrencyRate<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>where Currency = '€' or '$' or ...</P><P>where [Default Value] = the value in the default currency</P><P>where CurrencyRate = rate bewteen the default currency and the selected currency</P><P>The Currency and CurrencyRate fields will most likely be in your conversion table.</P></BODY></HTML> Fri, 05 Mar 2010 18:08:24 GMT 2010-03-05T18:08:24Z Transactions in different currencies https://community.qlik.com/t5/QlikView/Transactions-in-different-currencies/m-p/169728#M40420 <HTML><HEAD></HEAD><BODY><P>I have a number of transactions that I have converted to a single currency. My issue is that I must create charts where the user can select the display currency and all values will be displayed in the users desired currency.</P><P></P><P>Can anyone point me to the best way to do this. I have a currency conversion table also.</P><P>I am a Qlikview novice</P><P></P><P>Thanks in advance</P><P>Paul</P></BODY></HTML> Fri, 05 Mar 2010 10:51:02 GMT https://community.qlik.com/t5/QlikView/Transactions-in-different-currencies/m-p/169728#M40420 2010-03-05T10:51:02Z Transactions in different currencies https://community.qlik.com/t5/QlikView/Transactions-in-different-currencies/m-p/169729#M40421 <HTML><HEAD></HEAD><BODY><P>You can use an expression that looks something like this:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />=Currency&amp;' '&amp;[Default Value]*CurrencyRate<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>where Currency = '€' or '$' or ...</P><P>where [Default Value] = the value in the default currency</P><P>where CurrencyRate = rate bewteen the default currency and the selected currency</P><P>The Currency and CurrencyRate fields will most likely be in your conversion table.</P></BODY></HTML> Fri, 05 Mar 2010 18:08:24 GMT https://community.qlik.com/t5/QlikView/Transactions-in-different-currencies/m-p/169729#M40421 2010-03-05T18:08:24Z