Search by Keyword

Sense Excel the Add-In for Microsoft

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

Use the settings panel

You are here:
<< Back to all topics

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.

 

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Need help?