The AnalyticsGate 365 Online add-in enables access to the Qlik Sense platform directly from Microsoft Excel.
The add-in integrates Qlik Sense filter logic and enables loading, calculating and expanding data from Qlik Sense apps directly from Excel. After connecting the Qlik data model via the integrated data connector, all standard Excel features can be used in conjunction with the analysis capabilities of Qlik Sense.
The following functions are available:
You can see examples at https://docs.analyticsgate.com here under "Sense Functions in Excel":
AnalyticsGate 365 with Qlik Sense offers connectivity to a large number of data management tools including Office 365 SharePoint, AzureStorage, SQL, SAP, Power BI along with many others.
Comprehensive information about AnalyticsGate Qlik.SenseEV formulas and the AnalyticsGate Reporting Suite can be found in the AnalyticsGate 365 Knowledge Base at https://docs.analyticsgate.com.
The AnalyticsGate 365 Online add-in is provided under the same terms and conditions as other AnalyticsGate software as described here.
This provides the same safety, quality and reliability as the original standalone AnalyticsGate add-in and the complete AnalyticsGate product line.
Use of the AnalyticsGate 365 Online add-in for the browser version of Excel 365 requires access to a Qlik Sense server, either the AnalyticsGate Demonstration Server (https://playwith.analyticsgate.com/) or others using a trail or subscription license (https: // home .analyticsgate.com / contact-us /.
Use of the AnalyticsGate 365 online add-in for the browser version of Excel also requires access to Excel for the web ("Excel for the web") via either a trial (https://products.office.com/en-us) / try) or subscription license of Office 365.
If either your AnalyticsGate 365 and/or Office 365 Online trial have expired, you will need to purchase subscriptions to continue using these services.