QlikView integration with SharePoint 2013

As of the release of QlikView 11.20 SR5, QlikView Workbench includes integration with SharePoint 2013. This means QlikView can be integrated with SharePoint 2013 via div tags or via iFrame, displaying QlikView objects and allowing interaction.

There are two ways of including QlikView content on your SharePoint 2013 site pages:

  • As a Script Editor web part which require QProxy, or
  • As a Page Viewer web part (iFrame), which does not require QProxy.

QProxy

As of the release of QlikView 11.20 SR5, QlikView Workbench includes an updated proxy, QProxy.aspx.

It is possible to install only the QProxy. In such case, follow the installation procedure and select Custom setup and then select not to install Workbench but only the QProxy.

See: Installing QlikView Workbench

Editing web.config

Make sure that section configSections of the web.config file declares the proxy.

<configSections> <sectionGroup name="QProxy"> <sectionName="General" type="System.Configuration.NameValueSectionHandler" requirePermission="false" /> </sectionGroup> </configSections>

Then add the QProxy section and make sure it specifies the location of the QlikView Server (QvAjaxZfcPath).

<QProxy> <General> <add key="Proxy" value="/QProxy.aspx" /> <add key="LogFile" value="/QProxy_%date%.log" /> <add key="LogFilter" value="all, user, url, post, header, trace, response" /> <add key="Header" value="QVUSER" /> <add key="QvAjaxZfcPath" value="http://<QVSERVERNAME>/QvAjaxZfc/" /> </General> </QProxy>

Configurable Proxy

If the user identity in SharePoint is not in the exact same format as required by QlikView Server, the GetUserName function can be modified. In a configuration using header authentication, this function can help ensure that the user identity parsed to QVS is in the appropriate format.

Create Site Page - Script Editor Web Part

You can add QlikView content to your SharePoint 2013 web site via div tags. You insert a Script Editor web part and then you select to edit snippet. You then insert your div tags and also the Ajax Client location.

See: Connecting Workbench to QlikView Web Server.

Examples

Example 1: Connection Example:

Note: In the example below, 'Test' is the name of the QlikView document to view the objects from, and host defines the name of the server cluster.
<script type="text/javascript" src="http://<SharepointServerName>/QProxy.aspx?file=htc/QvAjax.js"> </script> <script type="text/javascript> QvInitWorkBench({ View: 'Test', Host: 'QVS@<QvServerName>' }); </script>

Example 2: Div Tags Example:

<div style="width:100px; height:150px; border-collapse:collapse;"> <div class="QvFrame" avqview="Test" avq="object: .Document\LB01" id="Document\LB01" style="display:none; width:100px; height:150px;"> </div> </div> <div style="width:408px; height:352px; border-collapse:collapse;"> <div class="QvFrame" avqview="Test" avq="object: .Document\CH01" id="Document\CH01" style="display:none; width:408px; height:352px;"> </div> </div>

Create Site Page - Page Viewer Web Part

Note: This scenario does not require QProxy to be installed.

You can add QlikView content to your SharePoint 2013 web site and display it via iFrame. For this you need to specify the URL and Object ID. You insert a Page Viewer web part and when you edit you define the URL and the SingleObject.htm and the ObjectID of the QlikView object you want to display.

Example: SingleObject Example

http://<QvServerName>/QvAjaxZfc/singleobject.htm?document=Sales%20Compass.qvw&host=QVS@<QvServerName>&object=CH351

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?