Installation of TRUECHART within QlikView

Supported Versions

Installation

Because the access of the AccessPoint is carried out by a web-browser, the use of trueChart is basically operating system independent. 

QlikView Desktop

QlikView AccessPoint

The QlikView AccessPoint is automatically delivered together with the QlikView Server Installation. So you don’t have to provide it separately. However, concerning the access of the AccessPoint, you have to keep in mind that trueChart is solely executable in the Ajax client. If you are using the Internet Explorer plug-in, you will not be able to use trueChart.

For the Ajax, client choose the option “Full Browser Version” in the AccessPoint to be the preferential method for the opening of QVWs (to be found in the menu item “Favourites & Profile”) or you adjust this setting for every QVW individually before the opening.

To enable trueChart on the QlikView Access Point. Download the Qlik View zip file from TrueChart Management Console :

Then extract the folder to:

C:\ProgramData\QlikTech\QlikViewServer\Extensions\Objects

Optional: EDX Web Server Installation

EDX Web Service technical requirements

As of version 1.9.5 trueChart provides the additional option to start EDX tasks on the QlikView Server directly from the client-side, for example, to perform a (partial) data reload.

In order to use this feature, the additional installation of the trueChart EDX Web Service is required. It is recommended to install this web service also on the QlikView Server system. The technical requirements therefore are:

• .NET Framework 4.0 (or higher)
• IIS 7 (or higher)

Create Local User for EDX Web Service

• Open Computer Management

• Create User Groups (Typically, these groups already exist on the QlikView Server)
  • QlikView EDX
  • QlikView Management API
• Create new User “trueChartEDX”
• Add new User “trueChartEDX” to User Groups
  • QlikView EDX
  • QlikView Management API
  • IIS_IUSRS

EDX Web Service Installation

Create IIS new application

• Unpack EDX_Wrapper_WebService.zip to your trueChart extensions folder “..\Software\QlikView Software\Extensions\trueChart (HiCo)\EDX_Wrapper”
• Open IIS-Management Console
• Perform Add Application to “Default Web Site”

• Set the physical path to your extraction folder “…\Software\QlikView Software\Extensions\trueChart (HiCo)\EDX_Wrapper”

Set EDXWrapper Service Web.Config to user “trueChartEDX”

• Change the Web Service web.config file at location “…\Software\QlikView Software\Extensions\trueChart (HiCo)\EDX_Wrapper\web.config”
• Change tag identity as follows:
  <identity impersonate="true" password="[edx user password]" userName="[add your edx user name]" />

Configure QlikView Management Web Services

• Change the Web Service web.config file at location “…\Software\QlikView Software\Extensions\trueChart (HiCo)\EDX_Wrapper\web.config”
• Specify QlikView version 11 or 12 (since trueChart version 1.9.6) in appSetting section

<appSettings>
    <!-- version specification for qlikview qms server version, possible values: 
          * QlikView: qv11, qv12
          * QlikSense: qs20, qs22 -->
    <add key="version" value="qv11" />
</appSettings>

• Change hostnames of publisher services QMS and IQTService for “endpoint”-tags in client-section for correct QlikView version.
• QlikView 11:
  • QlikView Management Service (contract="QmsAPI.v11.IQMS"): http://[publisher hostname]:4799/QMS/Service
  • QlikView IQTService (contract=”QmsAPI.v11.IQTService”): http://[publisher hostname]:4799/ANY/Service
• QlikView 12 (since trueChart version 1.9.6):
  • QlikView Management Service (contract="QmsAPI.v12.IQMS"): http://[publisher hostname]:4799/QMS/Service
  • QlikView IQTService (contract=”QmsAPI.v12.IQTService”): http://[publisher hostname]:4799/ANY/Service

<client>
      <!—QlikView Version 11 ->
      <endpoint address="http://[publisher hostname]:4799/QMS/Service"  binding="basicHttpBinding" bindingConfiguration="BasicHttpBinding_IQMS" contract="QmsAPI.v11.IQMS" name="BasicHttpBinding_IQMS" behaviorConfiguration="ServiceKeyEndpointBehavior" />
      <endpoint address="http://[publisher hostname]:4799/ANY/Service " binding="basicHttpBinding" bindingConfiguration="BasicHttpBinding_IQTService" contract="QmsAPI.v11.IQTService" name="BasicHttpBinding_IQTService" behaviorConfiguration="ServiceKeyEndpointBehavior" />

      <!—QlikView Version 12 ->
      <endpoint address="http://[publisher hostname]:4799/QMS/Service" bindingConfiguration="BasicHttpBinding_IQMS1" contract="QmsAPI.v12.IQMS" name="BasicHttpBinding_IQMS1" behaviorConfiguration="ServiceKeyEndpointBehavior" />
      <endpoint address="http://[publisher hostname]:4799/ANY/Service" binding="basicHttpBinding" bindingConfiguration="BasicHttpBinding_IQTService1" contract="QmsAPI.v12.IQTService" name="BasicHttpBinding_IQTService1" behaviorConfiguration="ServiceKeyEndpointBehavior" />
</client>

Change QlikView redirect settings in IIS

Depending on QlikView server installation, it is necessary to change also redirect settings in IIS as following:

• Open HTTP Redirect in IIS Management
• Set Option “Only redirect requests to content in this directory (not subdirectories)”

Create an EDX Task in QlikView Server Management Console

• Create EDX task (for (partial) reload) in QlikView Server to be used for configuration of corresponding trueChart Button cell

• Specify trigger type “On an external event” with password

Usage in trueChart Button

To trigger an edx task directly from trueChart, a button object must be defined with the corresponding function “Trigger EDX”. This function needs the following parameters:

• Taskname and EDX Trigger password: specified in the task creation step before.
• Web Service URL: to reflect any different server environments, such as development, quality assurance, and production, this URL should always be specified without hostname. Otherwise, the URL must be adjusted manually after a transport to another server: "/EDXWrapper/QlikViewTasks.asmx/TriggerEDXTask"