topic Re: Multiple Currency Conversion Issue? in QlikView https://community.qlik.com/t5/QlikView/Multiple-Currency-Conversion-Issue/m-p/112718#M762674 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try using below expression</P><P>=Sum(Amount/PDR)</P></BODY></HTML> Wed, 08 Aug 2018 09:59:30 GMT pooja_prabhu_n 2018-08-08T09:59:30Z Multiple Currency Conversion Issue? https://community.qlik.com/t5/QlikView/Multiple-Currency-Conversion-Issue/m-p/112717#M762673 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm quite new to Qlikview and learning as I go along so I'm sorry if this is really obvious.</P><P></P><P>I have a Qlikview where the data I bring in is in Local Currency but the Qlikview needs to be in USD. I have therefore added a PDR rate file to convert the values which works perfectly when working with one currency. But if I then make a chart that requires multiple currencies converting to USD together, it doesn't work. I've attached an example. Is there a way around this as I really need to be able to use all 5 currencies converting into USD.</P><P>Similarly, when making a table, the total will not calculate if there are multiple currencies but works fine if I filter just for one currency companies etc.</P><P></P><P>Thank you in advance <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Multiple-Currency-Conversion-Issue/m-p/112717#M762673 Anonymous 2020-11-25T16:16:04Z Re: Multiple Currency Conversion Issue? https://community.qlik.com/t5/QlikView/Multiple-Currency-Conversion-Issue/m-p/112718#M762674 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try using below expression</P><P>=Sum(Amount/PDR)</P></BODY></HTML> Wed, 08 Aug 2018 09:59:30 GMT https://community.qlik.com/t5/QlikView/Multiple-Currency-Conversion-Issue/m-p/112718#M762674 pooja_prabhu_n 2018-08-08T09:59:30Z Re: Multiple Currency Conversion Issue? https://community.qlik.com/t5/QlikView/Multiple-Currency-Conversion-Issue/m-p/112719#M762675 <HTML><HEAD></HEAD><BODY><P>Thank you so much that worked! Seems so obvious now!!</P></BODY></HTML> Wed, 08 Aug 2018 11:17:16 GMT https://community.qlik.com/t5/QlikView/Multiple-Currency-Conversion-Issue/m-p/112719#M762675 Anonymous 2018-08-08T11:17:16Z