9 Replies Latest reply: Feb 3, 2014 12:09 PM by Clever Anjos RSS

    Getting currency from internet

      Guys, good morning,

       

      I need to get currency exchange at the internet. For this I use an Excel file that generates the URL final part, to get everything until today, and then I go to the site and get the .xls file. After I get the file and the BR currency I do the inverse (1/value I get), and then I load it in the script. Also, some of the days it's blank the space, because either it's weekends, or holidays. So, I need that to be repeated the last number in those blank fields.

       

       

       

      Can someone help me by doing it directly on qlikview???

       

      these are the files: