How can we help?

AnalyticsGate 365 Add-In for Microsoft

Filtern nach Kategorie Ergebnisse löschen

AnalyticsGate Community | Microsoft Excel Help | Qlik Sense Help

Installation Add-In

Microsoft Office Excel Add-In

on Client PC
on Terminal Server
- Deploy Add-In on Server or Terminal Server
- Installation Steps Server rollout
License
365 Web Add-In
- Add Web Add-In to White List

Get new Version
Requirements
AnalyticsGate Examples Package Installation Guide
Excel File Demo - Executive-Dashboard
Get the "AG-Install-Updater.exe" (Setup installation)
Quik step by step

User Interface

Microsoft Office Excel Add-In

Overview [ sections ]
- Sense Excel Toolbar Overview
[ Connections ] section
[ Apps ] section
- HUB
[ Actions ] sections
[ Sense Reporting ] section
[ Settings ] section
- Use the settings panel
[ SheetLoop ] dynamic
- create a SheetLoop (dynamic loop) in Excel Template
[ QMC ] settings
- disable load data option in Add-in Toolbar

Sense Functions in Excel

Qlik Sense formulas in Excel

SenseEV
SenseVariable
SenseFilter
SenseConnected
Excel cell calculation from Qlik Sense table object
SenseCalculating

Installation Reporting Engine

Qlik Sense Extension and Windows service

Requirements
Install AnalyticsGate Reporting Suite
Qlik Sense Deployment Reporting Suite
Add Security rules for Reporting Suite

Installation AMC

Qlik Sense Extension

Install the AnalyticsGate "Management Console" = AMC

Installation On-Demand

Qlik Sense Extension

Install the On-Demand Qlik Sense Extension

Scripting for hjson

Please start with the Index - Overview part

Overview
- Overview about reporting json setting
Task
- Meta
  - name
  - description
- Reports
  - General
    - Info
    - timeout
    - autoFitTables
    - disableAutoLink
    - disableAdvancedTableMode
    - usePerfomanceAnalyzer
    - errorRepeatCount
    - cpuLimitInCore
    - memoryLimitInGB
  - Template
    - Selections
      - selections
      - objectType
      - type
      - name
      - values
      - sorted
  - Connections
    - app
    - connections
  - Distribute
    - Mail
      - MailServer
        
        mailserver
      - sendAttachment
      - active
  - File
    - target
  - Hub
    - mode
    - owner
  - Info
  - reports
- info

Management Console Interface

Reporting Suite Qlik Sense extension

How can I create an automated report for HUB
Ho to create an automated report in a Folder
Send Report without a attachement

On Demand Interface

Reporting Suite Qlik Sense extension

Overview
- Config a Qlik Sense on demand report

Troubleshooting FAQ

Articles coming soon