Sense Excel the Add-In for Microsoft
If you miss something please send us an email. Thanks!
Quick Start Guide – Excel Add-In
Download Installer
Download the Installer Tool from here, enter your contact information and click the “Request free Download” button. After filling out the contact form you will receive an email with the download link and further information. Save the Add-In in any folder and execute the installer.
Note: You need administration rights to install the required .NET 6 framework.
Open Examples
In the installation directory “C:\Users\<YourUser>\AppData\Roaming\AnalyticsGate” you will find some templates that you can open and test in Excel.
Add a security rule
In order for AnalyticsGate to have access to your licence, you must create a security rule. We match the AnalyticsGate license with your Qlick Sense serial number. This rule allows to read this Serial Number to match the AnalyticsGate license.
| Setting | Value |
| Name | AG_License |
| Ressource filter | License_* |
| Conditions | !user.IsAnonymous() |
| Context | Both in hub and QMC |
Add License to Content Libraries
Upload the AnalyticsGate license.txt to your Qlik Sense Server and create a new content library “analyticsgate”
The new content library saved the “license.txt” on your Qlik Sense server.
Go to https://your-qlik-sense-server.com/qmc >> Content libraries
Add a security rule for the “AnalyticsGate License”
You should create a security rule to read the license.
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.
If you want to limit the user usage time you can enter a start “Activated From” and end “Activated Until” date.
Check the Number of Users
Take a look into the License overview to find the value “EXCEL_NAMED”.
No Comments