topic Regarding loading a web page into QlikView in QlikView

Regarding loading a web page into QlikView

Tue, 06 Jan 2015 17:32:01 GMT

Hello Friends,

I appreciate your time. I am trying to upload the below web spreadsheet from the link into QlikView but it is not loading as expected, kindly let me know your opinions.

https://docs.google.com/spreadsheets/d/1qSi5Hl9sMWY0bIS11x4DHNNI7uwhSWT1jZ09KI1LOmI/edit#gid=0

Kind regards,

Kiruhe

Re: Regarding loading a web page into QlikView

sunny_talwar — Tue, 06 Jan 2015 18:05:15 GMT

This Google drive link is inaccessible. May be the same authentication issue is stopping the QlikView to load the data.

Best,

Re: Regarding loading a web page into QlikView

Tue, 06 Jan 2015 18:16:31 GMT

Hello Sunindia,

Thanks so much for your time and I sincerely appreciate it.

Actually I can be able to reload the original link but when I create a new sample link it is not accessing. Is there any way to remove this authentication so that it can get reload into QlikView? Kindly let me know if there is any.

Regards,

Kiru

Re: Regarding loading a web page into QlikView

jaimeaguilar — Tue, 06 Jan 2015 18:18:13 GMT

Hi,

I think your question has to do with permission issues. You need to have access granted to the document before you can load it from QlikView. Also you can try with qvsource in order to connect to that document,

regards

Re: Regarding loading a web page into QlikView

sunny_talwar — Tue, 06 Jan 2015 18:22:45 GMT

I have never done it before, but this link might be useful: Load from google drive

Best,

Re: Regarding loading a web page into QlikView

Tue, 06 Jan 2015 18:23:35 GMT

Hello Jaime,

Thanks and I appreciate your time. Is there any specific icon in the document do I need to click to grant access ?? I am not sure how to grant access and actually I have created that document.

Kindly let me know ..,

Thanks,

Kiru

Re: Regarding loading a web page into QlikView

Tue, 06 Jan 2015 19:53:30 GMT

Hello Friends,

Thanks and finally I found a way to share google drive doc into QV.

I have included the link as well as my appln for your reference, kindly let me know the way to fetch the column name for the fields.

Demo - Google Sheets

Thanks,

Kiru

Re: Regarding loading a web page into QlikView

sunny_talwar — Tue, 06 Jan 2015 20:18:26 GMT

Not sure if this is very helpful and there might be a better way to do it. But still have a look and see if this is helpful.

Best,

Re: Regarding loading a web page into QlikView

Anonymous — Tue, 06 Jan 2015 20:24:56 GMT

this should help:

Data:

LOAD A,
B
FROM
[https://docs.google.com/spreadsheets/d/1q7PLgxwRKnTiLhXlWWt5pYgJj_tO3alHYpA0_Bwmztw/edit#gid=0]
(html, codepage is 1252, embedded labels, header is 1, table is @2)
Where A <> ''
;

Re: Regarding loading a web page into QlikView

Tue, 06 Jan 2015 20:27:39 GMT

That's great and thanks so much..,this is what I want exactly :-))

I have another query, if a column contains navigation links then is it possible to navigate it to the corresponding page by clicking on the link.

Say for eg: column name as Link and which contains the field link: a google link.

so after reloading, when I take the link column in a list box and then by clicking on google link, will it navigate to google page?

My sincere thanks to your timely help again!!

Kiru

Re: Regarding loading a web page into QlikView

sunny_talwar — Tue, 06 Jan 2015 20:42:31 GMT

Found a way to create a clickable link on a straight chart. But couldn't find one for list box.

Best,

Re: Regarding loading a web page into QlikView

Tue, 06 Jan 2015 20:48:44 GMT

That's awesome!!

Thanks,

Kiru