Search by Keyword
Sense Excel the Add-In for Microsoft
If you miss something please send us an email. Thanks!
Use the settings panel
Chosing “Settings”
… from this menu will activate the AnalyticsGate Settings Panel.
This interface allows a number of behaviors to be enabled or disabled as well as parameters values set on a local or global (your AnalyticsGate installation) basis.
Lokal settings onyl for the current open document
[ Setting ]: “Ignore Selections while Selections tool is open” | default: true
While the selections tool is open, changing a selection has no effect to Tables/SenseEV’s.
After the selections tool is closed, all changes will be applied in one step. So the selections tool is faster.
If disabled: All selections are calculated immediately when they are set!
[ Setting ]: “Ignore Selections while a listbox is open” | default: true
While a listbox of a selectionitem is open, changing a selection has no effect to Tables/SenseEV’s.
After the listbox is closed, all changes will be applied in one step. So the listbox is faster.
[ Setting ]: “Open app in a shared session” | default: true
If you open an app in your Sense Server/Desktop which is also opend in Senseexcel, then all selections made in Senseexcel will be applied in Senseserver/Desktop and vice versa.
[ Setting ]: “Show UserInfo’s when AnalyticGate is busy” | default: true
If is disabled you don’t see the side panel on right side with interactions infos
[ Setting ]: “Show UserInfo for SenseEV Calculations” | default: true
While calculating SenseEV Formulas a Panel with the progress is opened.
[ Setting ]: “Show Enigma Logging” | default: false
Enigma logs Qlik Server communication. This results in a larger logfile. In normal cases this is not nessecary.
[ Setting ]: “Keep Qlik session alive while Excel is open” | default: true
Enigma logs Qlik Server communication. This results in a larger logfile. In normal cases this is not nessecary.
[ Setting ]: Show UserInfo’s in english (Support Only) | default: false
Translate all log information into English. Support infos are in different language with this setting it wil be force in English.
[ Setting ]: Check for remainig excelprocess | default: true
Check if after closing excel a ‘ghost’ process remains and close it.
[ Setting ]: Open the Hub after a successful connect true | default: true
Worklow after you connected to the Qlik Sense Server. Default settings open the HUB automatically after you are connected to.
[ Setting ]: Automatically open the last connection and last Qlik App | default: true
Worklow when you open a Excel with AnalyticsGate settings insights. We try to connect your server with the last connection and with the last user credentials.
[ Setting ]: Show Warnmessage when Table results will be truncated | default: true
If a table is requested where the row count is larger than the limit, an warning is displayed and additional confirmation is needed to proceed.
[ Setting ]: Time (ms) after a app-open proccess is canceled | default: 5000
If an open app proccess has not been finished in this time it will be canceled. Adjusting this Time is usefull on slow machines or slow network connection.
[ Setting ]: Time (ms) after a connection-open proccess is canceled | default: 5000
If an open connection process has not been finished in this time it will be canceled. Adjusting this Time is usefull on slow machines or slow network connection.
[ Setting ]: Timeout (ms) for detecting that a Qlik session is expired | default: 3000
Workflow process for spcial enviorment.
[ Setting ]: Max Number of parallel SenseEV Calculations | default: 200
“Recommended is 200. A higher value leads to faster SenseEV-calculation but can cause problems on Servers because of to many Requests fired in a short amount of time.”
[ Setting ]: Time in milliseconds after check for a ‘ghost’ process is started | default: 5000
Check if after closing excel a ‘ghost’ process remains and close it.
[ Setting ]: Ignore the specified file| default: PERSONAL.XLSB
When saving “Macros” to personal workbook. A file personal.xlsb is created in the XLStart folder and is loaded when every Excel start.
[ Setting ]: Ignore files from XLStart| default: true
Documents in the XLStart folder of Excel (%Appdata%\Microsoft\Excel\XLSTART) serve only as templates or libraries and are ignored by Analyticsgate,
because they do not contain any elements to be calculated.
No Comments