topic Sum of different currencies in QlikView https://community.qlik.com/t5/QlikView/Sum-of-different-currencies/m-p/128154#M19387 <HTML><HEAD></HEAD><BODY><P>Hello.<BR />Here is a example of my table.</P><P></P><P></P><TABLE border="1" class="jiveBorder" height="115" style="border: 1px solid rgb(0, 0, 0); width: 220px; height: 103px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P style="padding-left: 30px;">Currency</P><P></P></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Amount</STRONG></TH></TR><TR><TD style="padding: 2px;">Euro</TD><TD style="padding: 2px;">33</TD></TR><TR><TD style="padding: 2px;">USD</TD><TD style="padding: 2px;">11</TD></TR><TR><TD style="padding: 2px;">GBP</TD><TD style="padding: 2px;">44</TD></TR><TR><TD style="padding: 2px;">AUD</TD><TD style="padding: 2px;">22</TD></TR></TBODY></TABLE><P></P><P>How it's possible to sum these different amounts as total in EURO.<BR />Thanks!</P></BODY></HTML> Tue, 28 Aug 2018 13:15:18 GMT v_ganchev 2018-08-28T13:15:18Z Sum of different currencies https://community.qlik.com/t5/QlikView/Sum-of-different-currencies/m-p/128154#M19387 <HTML><HEAD></HEAD><BODY><P>Hello.<BR />Here is a example of my table.</P><P></P><P></P><TABLE border="1" class="jiveBorder" height="115" style="border: 1px solid rgb(0, 0, 0); width: 220px; height: 103px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P style="padding-left: 30px;">Currency</P><P></P></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Amount</STRONG></TH></TR><TR><TD style="padding: 2px;">Euro</TD><TD style="padding: 2px;">33</TD></TR><TR><TD style="padding: 2px;">USD</TD><TD style="padding: 2px;">11</TD></TR><TR><TD style="padding: 2px;">GBP</TD><TD style="padding: 2px;">44</TD></TR><TR><TD style="padding: 2px;">AUD</TD><TD style="padding: 2px;">22</TD></TR></TBODY></TABLE><P></P><P>How it's possible to sum these different amounts as total in EURO.<BR />Thanks!</P></BODY></HTML> Tue, 28 Aug 2018 13:15:18 GMT https://community.qlik.com/t5/QlikView/Sum-of-different-currencies/m-p/128154#M19387 v_ganchev 2018-08-28T13:15:18Z Re: Sum of different currencies https://community.qlik.com/t5/QlikView/Sum-of-different-currencies/m-p/128155#M19388 <HTML><HEAD></HEAD><BODY><P>You can create a currency exchange table and then simply multiply by the exchange rate.</P><P></P><P>AMOUNTS:</P><P>LOAD * INLINE [</P><P>Currency, Amount</P><P>EUR,33</P><P>USD,11</P><P>GBP,44</P><P>AUD,22</P><P>];</P><P></P><P>CURRXCHANGE:</P><P>LOAD * INLINE [</P><P>Currency, xRate</P><P>EUR, 1</P><P>USD, 1.1</P><P>GBP, 1.3</P><P>AUD, 2.6</P><P>];</P><P></P><P>In a table in a sheet in your application you could have an expression like this:</P><P></P><P>Sum( Amount ) * xRate</P><P></P><P>and have the dimension: Currency.</P><P></P><P>This is an overly simplistic example but it is basically this approach...</P></BODY></HTML> Tue, 28 Aug 2018 20:52:38 GMT https://community.qlik.com/t5/QlikView/Sum-of-different-currencies/m-p/128155#M19388 petter 2018-08-28T20:52:38Z