Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
Again seeking for your help, Every month I have to update my information with a new exchange rates (several countries, several rates), is it possible to multiple every currency by the must current exchange rate or any exchange rate I choose via Qlik Sense?. The source of the exchange rate values is a file that my company produces.
Thanks again.
Cheers
Hi,
You want to calculate all data with most current exchange rates? Easiest way is to calculate it using your load script. Below there is a brief example script for rates calculation:
-----------------------------------------------------------
//Data load from temp
DATA:
LOAD
Country,
UnitValue,
DataCurrencyCode
RESIDENT DATA_TEMP;
DROP TABLE DATA_TEMP;
//Exchange CSV load
ExchangeRates:
LOAD
CurrencyCode,
CurrencyRate
FROM [lib://CSV/ExchangeRates.csv]
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);
//Join Exchange to DATA
LEFT JOIN (DATA)
LOAD
CurrencyCode AS DataCurrencyCode,
CurrencyRate
RESIDENT ExchangeRates;
//Data load with group values
DATA_GROUP:
LOAD
Country,
UnitValue,
DataCurrencyCode,
CurrencyRate
UnitValue*CurrencyRate AS GroupValue
RESIDENT DATA;
DROP TABLE DATA;
-----------------------------------------------------------
BW,
Markus
Thank you Markus, will try and come back. Cheers
Hey there,
You can use the new feature of Qlik Sense named as "Qlik Sense Data Market" when you can upload a current exchange rate that is automatic updated. Here is how you do it:
See this video, form Michael Tarallo, in minute 6 aproximatly:
Qlik Sense - Using Qlik DataMarket - YouTube
Regards,
MB