topic Re: exchange rates in App Development

exchange rates

Anonymous — Fri, 29 Jul 2016 06:45:56 GMT

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

Re: exchange rates

Anonymous — Fri, 29 Jul 2016 08:46:28 GMT

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

Re: exchange rates

Anonymous — Fri, 29 Jul 2016 09:35:26 GMT

Thank you Markus, will try and come back. Cheers

Re: exchange rates

miguelbraga — Fri, 29 Jul 2016 09:51:33 GMT

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,