Regarding loading a web page into QlikView

[#1]

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

[sunny_talwar]

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

Best,

S

[#3]

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

[jaimeaguilar]

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

[sunny_talwar]

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

Best,

S

[#6]

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

[#7]

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

[sunny_talwar · Accepted solution]

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,

S

[Anonymous]

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 <> ''
;

[#10]

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