topic Re: share point connection in QlickView in QlikView

share point connection in QlickView

Mon, 16 Nov 2015 12:22:36 GMT

Hi All,

I have couple of questions :

1) when I define my share point web address with a parameter(for example, I called it "vSharepointPath") , should I write it with the "http://" or without it ?

2) when I do the select from the excel file in the share point like that :

LOAD [Year]

FROM [$(vSharepointPath)excel_file.xlsx] (ooxml, embedded labels, table is [sheet_name]);

the data does not load at all - what am I doing wrong in my definition ?

thanks,

Moni

Re: share point connection in QlickView

Anonymous — Mon, 16 Nov 2015 13:31:53 GMT

may be useful for you:

Reading Data from Sharepoint lists into QlikView

Extracting sharepoint list data into qlikview

How to connect sharepoint with qlikview ?

Re: share point connection in QlickView

Tue, 17 Nov 2015 06:50:54 GMT

thanks you for your answer ,

but still I get difficult to understand how to use the URL with the listGUID:

when I trying to load the file (excel) from it like that :

load *

from [https://xx.sharepoint.com/teams/xxxxxxxx/_layouts/15/policycts.aspx?List={ADF28588-EBE9-49D5-ABE4-E21FB6740638}] (ooxml, embedded labels, table is [sheet_name])

it doesn't work .

where do I put the file name here in the link ?

I have on the share point 3 excels files , how do I address to a specific one with this url ?

thanks

Moni