Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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:

1 Solution

Accepted Solutions
cuv
Not applicable

Re: Getting currency from internet

PFA

9 Replies
MK_QSL
Not applicable

Re: Getting currency from internet

Check enclosed example.. which might useful to you.

Not applicable

Re: Getting currency from internet

Thanks, this might help the second part of my problem (:

Not applicable

Re: Getting currency from internet

Anyone can help me with that?? Any solution is good for me, as long as I press reload button and gets from internet, no matter which site...

Not applicable

Re: Getting currency from internet

Anyone has any tip on that to help me please?

Not applicable

Re: Getting currency from internet

Have you encountered any problem with Manish solution?

Not applicable

Re: Getting currency from internet

Hi,

Take a look at the script under the below thread:

http://community.qlik.com/message/231010#231010

cuv
Not applicable

Re: Getting currency from internet

PFA

Not applicable

Re: Getting currency from internet

Problem is that I need to get the real currencies from the internet, with no manual step of extracting any data... Do you know how can we do that?

this thread here helped me somehow, but i need to get the brazilian currency now aswell...

http://community.qlik.com/message/231010#231010

cuv
Not applicable

Re: Getting currency from internet

Please check your email. I´ve just sent you an example