Sense Excel, the Add-In for Microsoft

If you miss something please send us an email. Thanks!

<< Back to all topics
You are here:
Print

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.

Follow the instructions on your screen.

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 us to read this serial number to do the matching.

Setting Value
Name AG_License
Resource filter License_*
Conditions !user.IsAnonymous()
Context Both in hub and QMC

 

Add License to Content Libraries

Upload the AnalyticsGate license file “license.txt” to your Qlik Sense Server and create a new content library “analyticsgate”

This content library will hold the file “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 file “license.txt” to the content library “analyticsgate”

To get a quicker overview of your licence information, you can install the Qlik extension AG Web Management at the following link.

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 date  in “Activated From” and an end date in “Activated Until”.

Check the Number of Users

Take a look into the License overview to find the value “EXCEL_NAMED”.

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
Please Share Your Feedback
How Can We Improve This Article?
Need help?
No Comments

Post a Comment

Comment
Name
Email
Website