topic Sharepoint list - lookup column caused a problem in QlikView https://community.qlik.com/t5/QlikView/Sharepoint-list-lookup-column-caused-a-problem/m-p/496399#M692873 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I had a problem loading a sharepoint list into qlikview via owssvr.dll (<A href="http://your-sharepoint-server/site/_vti_bin/owssvr.dll?Cmd=Display&amp;XMLDATA=1&amp;RowLimit=0&amp;List=listGUID&amp;View=viewGUID" title="http://your-sharepoint-server/site/_vti_bin/owssvr.dll?Cmd=Display&amp;XMLDATA=1&amp;RowLimit=0&amp;List=listGUID&amp;View=viewGUID">http://your-sharepoint-server/site/_vti_bin/owssvr.dll?Cmd=Display&amp;XMLDATA=1&amp;RowLimit=0&amp;List=listGUID&amp;View=viewGUID</A>). The connection between qlikview and the list just could not be established. Sometime (but not evertime) I received "Server response could not be parsed" as an error.</P><P></P><P>However - I found a way to work around the problem. There is a lookup column in my sharepoint list which refers to a document library. This lookup column prooved to be the troublemaker. The workaround is to create a list view that does not contain the lookup column an refer to this viewGUID. With that "de-troubled" view everything works fine.</P><P></P><P>It would be interesting if anybody has solved the problem of loading the content of a lookup column as such. To me it seems reasonable enough to load both sources an let qlikview do the lookup.</P><P></P><P>Martin</P></BODY></HTML> Mon, 09 Sep 2013 08:46:37 GMT 2013-09-09T08:46:37Z Sharepoint list - lookup column caused a problem https://community.qlik.com/t5/QlikView/Sharepoint-list-lookup-column-caused-a-problem/m-p/496399#M692873 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I had a problem loading a sharepoint list into qlikview via owssvr.dll (<A href="http://your-sharepoint-server/site/_vti_bin/owssvr.dll?Cmd=Display&amp;XMLDATA=1&amp;RowLimit=0&amp;List=listGUID&amp;View=viewGUID" title="http://your-sharepoint-server/site/_vti_bin/owssvr.dll?Cmd=Display&amp;XMLDATA=1&amp;RowLimit=0&amp;List=listGUID&amp;View=viewGUID">http://your-sharepoint-server/site/_vti_bin/owssvr.dll?Cmd=Display&amp;XMLDATA=1&amp;RowLimit=0&amp;List=listGUID&amp;View=viewGUID</A>). The connection between qlikview and the list just could not be established. Sometime (but not evertime) I received "Server response could not be parsed" as an error.</P><P></P><P>However - I found a way to work around the problem. There is a lookup column in my sharepoint list which refers to a document library. This lookup column prooved to be the troublemaker. The workaround is to create a list view that does not contain the lookup column an refer to this viewGUID. With that "de-troubled" view everything works fine.</P><P></P><P>It would be interesting if anybody has solved the problem of loading the content of a lookup column as such. To me it seems reasonable enough to load both sources an let qlikview do the lookup.</P><P></P><P>Martin</P></BODY></HTML> Mon, 09 Sep 2013 08:46:37 GMT https://community.qlik.com/t5/QlikView/Sharepoint-list-lookup-column-caused-a-problem/m-p/496399#M692873 2013-09-09T08:46:37Z Re: Sharepoint list - lookup column caused a problem https://community.qlik.com/t5/QlikView/Sharepoint-list-lookup-column-caused-a-problem/m-p/496400#M692874 <HTML><HEAD></HEAD><BODY><P>I am having the same error and I think it may also be related to a new lookup field. Any resolution?</P></BODY></HTML> Tue, 19 Aug 2014 21:21:02 GMT https://community.qlik.com/t5/QlikView/Sharepoint-list-lookup-column-caused-a-problem/m-p/496400#M692874 cbaqir 2014-08-19T21:21:02Z