3 Replies Latest reply: Jul 29, 2016 5:35 AM by Victor Barradas RSS

    exchange rates

    Victor Barradas

      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
          Markus Määttälä

          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
            Miguel Braga

            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