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
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?
