Tip: Start typing in the input box for immediate search results.
Quick Start Guide – Excel Add-In
Download installer tool
Download the Installer Tool from here and click on “AnalyticsGate” Add-in for Microsoft button



In the background we save the download file in your app directory from the user profil like this: “C:\Users\%USERNAME%\AppData\Roaming\Analyticsgate\”

Open Example
With download we have downloaded you a sample file for Excel. In this example you will be guided step by step.




Expert Mode
Expert mode switch – shows the “RoomID” channel mode.
The Room ID mode allows to input “Room-Ids” for example: “old” so you can switch to older versions or Beta like that.
for sure, you can switch to special versions e.g. every time.

Add a security rule
…to ready the license from the server ( we match the AnalyticsGate license with you QS serial number)
This rule allows to read Qlik Sense Serial Number to match the AnalyticsGate license.
Add a ContentLib
…to upload the license.txt to your Qlik Sense Server you need a new content libary “analyticsgate”!
Add a new content library “analyticsgate” (formerly “senseexcel”)
The new content library saved the “license.txt” on your Qlik Sense server!
Got to https://your-qlik-sense-server.com/qmc >> Content libraries
2. Create new “analyticsgate” (formerly “senseexcel”) and select the “ser” and “analyticsgate” TAG
3. Configure only one security rule “AnalyticsGate License” (formerly “Sense Excel License”)
4. Upload your license.txt to the content library “analyticsgate”
Allocate the User
If you have installed the “SMC” you can allocate users in a very easy way
(optional) you can set a “activated from / until” date
How many users can add to?
Take a look into the License overview and find the value “EXCEL_NAMED”.. there you will find the maximum value!