topic Re: Connect to data in web!!! in QlikView

Connect to data in web!!!

Tue, 19 Jan 2016 15:47:50 GMT

Dear QV Experts,

Is it possible to connect to the spreadsheet placed in web & refresh periodically?

Appreciate your prompt response.

Thanks

Sasi

Gysbert_Wassenaar — Tue, 19 Jan 2016 16:08:26 GMT

Maybe. It depends how the spreadsheet is published on the web.

engishfaque — Wed, 20 Jan 2016 03:44:59 GMT

Dear Sasi,

Yes it is possible.

Here is the link where from I am loading data into QlikView,

File Name is,

AFN01.xls

Steps:

Edit Script > Web Files > Internet File >

> Next > Finish.

Kindly find attached App.

Kind regards,

Ishfaque Ahmed

HirisH_V7 — Wed, 20 Jan 2016 04:16:59 GMT

Hi,

You can access Google Sheets

Create your Google Sheet then Google will generate a link. Copy it
Into QlikView Script, there´s a button "Web Files", use that link to open your document

Else

Hope this Helps,

Hirish

Wed, 20 Jan 2016 12:05:25 GMT

Thanks All for your valued suggestions.