QlikSense licence port

URL is: lef1.qliktech.com

And the IP is 188.65.156.73 over port 80.

If the server can’t reach the outside because of a firewall, you can manually enter the key using LEF generator:

http://lef1.qliktech.com/manuallef/default.aspx

https://community.qlik.com/thread/135107

QlikSense Map point

Need to bring in the Latitude and Longitude.

Create a new dimension member with the points plotted as below:

=GeoMakePoint(Latitude,Longitude)

QlikSense: Creating QVD file and pointing data

Within an app simply point the script table to the created folder location created ("QVDFiles")

1. Load into QVD

//SQL Connection and query

LIB CONNECT TO [DBConnection];

[vwDimClient]:

LOAD 

[Client],

        [Column2] AS [Measure];

SQL SELECT "Client",

"Column2"

FROM "dbo"."vwTABLE" Where CountryCode = 'US';

//Where going to store and then drop the table created

STORE [vwDimClient] INTO [lib://QVDFiles/Client.qvd](qvd);

DROP Table [vwDimClient];

//Add when want to exit load

EXIT SCRIPT;

2. Point tables to qvd files

You then need to update script to point to qvd instead of table:

//Load from QVD

[vwDimClient]:

LOAD 

[Client],

        [Measure]

FROM [lib://QVDFiles/Client.qvd](qvd);

Creating a Reverse Proxy

1- Install the following in IIS (Windows Features if not enabled)
a. ARR
b. URL Rewrite
c. Enable http redirection and web socket protocol

2- Create an inbound rule in IIS:

3- Add following rules (*3)

4 - Finally in QMC add virtual proxy host lists

Reverse Proxy Architecture

QlikSense Scheduler Task keeps resetting and cannot run tasks

You need to rebuild the Performance Counters as they maybe corrupt.

Got to cmd

Rebuilding the counters:
     cd c:\windows\system32
     lodctr /R
     cd c:\windows\sysWOW64
     lodctr /R

Resyncing the counters with Windows Management Instrumentation (WMI):
     WINMGMT.EXE /RESYNCPERF

QlikSense Services do not start

This is due to the ServicesPipeTimeout. You must increase this to 2 minutes as follows:

To increase the service start up timeout by entering the following registry entry:

1. Cmd > Regedit
2. Go to folder: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control
3. Right client control folder > New and select DWORD Value.
4. Name = ServicesPipeTimeout
5. Set Value to 120000 (As Decimal / 120000ms = 2minutes)
6. Quit Registry Editor and restart computer.. Services should now be up and running.