topic Re: Web files in Qlikview in QlikView

Web files in Qlikview

Wed, 02 Jul 2014 10:08:38 GMT

Hi,

I'm using Qlikview personal edition 11.20. When i click on the edit script , on the right hand side there is "Web Files" . What it is and why it is used? Also what kind of files / file extension can be used for this ?

Thanks,

Shree

Re: Web files in Qlikview

Wed, 02 Jul 2014 10:14:09 GMT

Web files are those data residing in Web.

For eg: To access an excel file in SharePoint site you will have to provide the Url and the data will be fetched accordingly.

Same is the case for Web service.

Regards,

Prabhu

Re: Web files in Qlikview

ashfaq_haseeb — Wed, 02 Jul 2014 10:16:30 GMT

Hi,

It is used to read data from internet/ Website reside in html tables.

Look at the attached example.

Regards

ASHFAQ

Re: Web files in Qlikview

sundarakumar — Wed, 02 Jul 2014 10:25:25 GMT

As you are having personal edition u might not be able to open Mohammed app.

In edit script

load

Capaicty,

Premium

FROM

[http://community.qlik.com/message/534444#534444]

(html, codepage is 1252, embedded labels, table is @1);

this will tell qlikview to see for any table that is present in the particular link. i.e. [http://community.qlik.com/message/534444#534444].

Please refer there is a table in that link and the output in the reload is

u just need to give the link to fetch data in that link..

Hope this helps.

_Sundar

Re: Web files in Qlikview

Wed, 02 Jul 2014 10:27:00 GMT

hi, can u send me the screen shot as i'm using personal edition , not able to view the document which u have attached.

Re: Re: Web files in Qlikview

ashfaq_haseeb — Wed, 02 Jul 2014 10:35:50 GMT

Hi go to edit script

Click on web file copy below url in internet file option

Re: Pivot table

Click next.

Look at the attached image.

Regards

ASHFAQ

Re: Web files in Qlikview

Wed, 02 Jul 2014 10:36:15 GMT

Hi i used teh same link which u have given :

Re: Pivot table

When i selected teh web file and pasted teh ablove url and clicked next and finished. When i selected the fiels i'm getting something different as below:

Re: Re: Web files in Qlikview

ashfaq_haseeb — Wed, 02 Jul 2014 10:39:23 GMT

Hi after you hit next you will get something like this.

then click on finish.

Look at the attached image.

Regards

ASHFAQ

Re: Re: Web files in Qlikview

Wed, 02 Jul 2014 11:39:46 GMT

Hi, when i do so i'm getting error.

Re: Re: Re: Web files in Qlikview

ashfaq_haseeb — Wed, 02 Jul 2014 11:46:42 GMT

Hi,

Might be you need to logged in to community.

Try the attach open url instead.

Regards

ASHFAQ

Re: Re: Re: Web files in Qlikview

Thu, 03 Jul 2014 06:42:34 GMT

Hi,

I have in stalled Qlikview personal edition 11.20 on 2 machines. I ahve used the web file link as below:

List of countries by population - Wikipedia, the free encyclopedia

In one machine i'm able to see the data as a table but on the other machine it's saying "proxy authentication required". But on the both the machines the proxy setting are same. So what's needs to be done ? is there any other settings to be done?

Secondly, on what basis data is captured from the web site? What kind of data are captured as a tables in Qlikview from website. In the below screen shot on what basis @1, @2 ... will be captured.

Re: Web files in Qlikview

ashfaq_haseeb — Thu, 03 Jul 2014 08:17:40 GMT

Hi,

Its basically HTML file data.

There is nothing at Qlikview level you just need to recheck proxy setting.

Hope it helped

Regards

ASHFAQ