topic Dividing values based on current exchange rates in QlikView https://community.qlik.com/t5/QlikView/Dividing-values-based-on-current-exchange-rates/m-p/734564#M1075064 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>Kindly need your help</P><P></P><P>I have a table in database which contains exchange rates, currency key, code, the exchange rate gets updated like everyday or alternate days, I managed to create a chart in Qlik to get only the last updated exchange rates from the database, using aggr function in the expression</P><P></P><P>I have a table with balance information, I have to divide each value in the balances column with their corresponding exchange rates based on currencykey which is a common key between both the tables, could some one please guide me on how to go about it?</P><P></P><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 23 Jul 2014 13:09:50 GMT 2014-07-23T13:09:50Z Dividing values based on current exchange rates https://community.qlik.com/t5/QlikView/Dividing-values-based-on-current-exchange-rates/m-p/734564#M1075064 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>Kindly need your help</P><P></P><P>I have a table in database which contains exchange rates, currency key, code, the exchange rate gets updated like everyday or alternate days, I managed to create a chart in Qlik to get only the last updated exchange rates from the database, using aggr function in the expression</P><P></P><P>I have a table with balance information, I have to divide each value in the balances column with their corresponding exchange rates based on currencykey which is a common key between both the tables, could some one please guide me on how to go about it?</P><P></P><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 23 Jul 2014 13:09:50 GMT https://community.qlik.com/t5/QlikView/Dividing-values-based-on-current-exchange-rates/m-p/734564#M1075064 2014-07-23T13:09:50Z