Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

ruthubarra
New Contributor II

exchange rates

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

Tags (1)
3 Replies
markusmaattala
New Contributor II

Re: exchange rates

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

ruthubarra
New Contributor II

Re: exchange rates

Thank you Markus, will try and come back. Cheers

miguelbraga
Valued Contributor III

Re: exchange rates

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