topic Re: Currency Conversion help please in QlikView https://community.qlik.com/t5/QlikView/Currency-Conversion-help-please/m-p/1041225#M942318 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Do you want All the amount convert&nbsp; all the Currency? if so, just join the two table then multiply it.</P><P>Like</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/112170_Capture.JPG" style="height: auto;" /></P><P><IMG alt="Capture.JPG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/112171_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Thu, 21 Jan 2016 03:48:03 GMT settu_periasamy 2016-01-21T03:48:03Z Currency Conversion help please https://community.qlik.com/t5/QlikView/Currency-Conversion-help-please/m-p/1041224#M942317 <HTML><HEAD></HEAD><BODY><P>I have 2 tables as below </P><P>Table1 :</P><P>ID Amount</P><P>1&nbsp;&nbsp; 450</P><P>2&nbsp;&nbsp; 680</P><P></P><P>Currency :</P><P>Curr&nbsp;&nbsp;&nbsp;&nbsp; FxRt</P><P>USD&nbsp;&nbsp;&nbsp; 1.16138809</P><P>ADP&nbsp;&nbsp;&nbsp;&nbsp; 3.6729844725</P><P>AFN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 60.8366792675</P><P></P><P></P><P>I want to convert Amount to diff currency based on the currency table.How can i acheive this ?</P><P></P><P>Thank you.</P></BODY></HTML> Thu, 21 Jan 2016 03:08:05 GMT https://community.qlik.com/t5/QlikView/Currency-Conversion-help-please/m-p/1041224#M942317 2016-01-21T03:08:05Z Re: Currency Conversion help please https://community.qlik.com/t5/QlikView/Currency-Conversion-help-please/m-p/1041225#M942318 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Do you want All the amount convert&nbsp; all the Currency? if so, just join the two table then multiply it.</P><P>Like</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/112170_Capture.JPG" style="height: auto;" /></P><P><IMG alt="Capture.JPG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/112171_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Thu, 21 Jan 2016 03:48:03 GMT https://community.qlik.com/t5/QlikView/Currency-Conversion-help-please/m-p/1041225#M942318 settu_periasamy 2016-01-21T03:48:03Z Re: Currency Conversion help please https://community.qlik.com/t5/QlikView/Currency-Conversion-help-please/m-p/1041226#M942319 <HTML><HEAD></HEAD><BODY><P>Dear Pavana,</P><P></P><P>Kindly find attached App.</P><P></P><P></P><P>Kind regards,</P><P>Ishfaque Ahmed</P></BODY></HTML> Thu, 21 Jan 2016 03:51:30 GMT https://community.qlik.com/t5/QlikView/Currency-Conversion-help-please/m-p/1041226#M942319 engishfaque 2016-01-21T03:51:30Z