topic Re: Load data from website in QlikView

Load data from website

its_anandrjs — Wed, 29 Jun 2011 17:33:11 GMT

Hi All,

I have a query that on that i loads data from website and there are links available. When i load the data it comes in the filed and when see the data it contains website address i want to use this address from QVW file to run the website. I am able to that by apply Actions->Add->External->Open URL on any simple Text Object but is there any way that i dont need to make a text object for every address. Is it possible that i take this in any object and use as to run the web address from there.

When i load data from website it looks likes following

Load data from website

Wed, 29 Jun 2011 17:52:49 GMT

You can do something like the following in any table:

=[Name]&'<url>'&'http://www.google.com/search?q='&Name

You would want to change it a bit for your use but something like =[Address]&'<url>'&'[Address] should work

Re: Load data from website

its_anandrjs — Wed, 29 Jun 2011 18:07:55 GMT

Hi Leonard,

I attached my QVW please explain on that. I load simple inline load not from website but it is same.

Anand

Re: Load data from website

Wed, 29 Jun 2011 18:15:39 GMT

Try something like the new chart I added to your file.

Re: Load data from website

Thu, 30 Jun 2011 06:22:47 GMT

Hi,

Follow a sper the attached file, need to activate a macro on the click of the link, please verify the document properties for setting up the macros on the event trigger.