2 Replies Latest reply: Jan 16, 2017 6:32 AM by Robert Hutchings RSS

    Qlik Data Market Currencies No longer works

    Robert Hutchings

      Hi

       

      It was working fine for the free currencies. It didn't work just before Christmas. I thought it was down temporarily.

       

      Its still not working. I need to know whether this has been discontinued as I need to do some work needing exchange rates

       

      Thanks

       

      DataMarket.JPG

        • Re: Qlik Data Market Currencies No longer works
          Jandré Killian

          Hi Robert

           

          Just ran mine and its running fine.

          I see you need to make 2 more selections. (You need 3 green marks)

           

          1.JPG

          Regards

            • Re: Qlik Data Market Currencies No longer works
              Robert Hutchings

              Thanks

               

              I can see what Qlik have done now

               

              They have made a change maybe from 3.1.2 on. It doesn't work with the way I used the script anymore.

               

              They use to load as separate tables. One for every currency

               

              Like so

               

              // from above Auto generated sheet

               

              XRPound:

              LOAD

                 "Base currency",

                  "Exchange rate"

              RESIDENT [3x3 currency exchange rates]

              where "Quote currency" = 'Pound sterling' ;

               

               

              XRDollar:

              LOAD

                 "Base currency",

                  "Exchange rate"

              RESIDENT [3x3 currency exchange rates]

              where "Quote currency" = 'US dollar' ;

               

               

              XREuro:

              LOAD

                 "Base currency",

                  "Exchange rate"

              RESIDENT [3x3 currency exchange rates]

              where "Quote currency" = 'Euro' ;

               

              drop table [3x3 currency exchange rates] ;

               

              but now its different. Using a link table instead

               

              I will have give this some thought as I used Qliks market script for mapping tables