Settings

Server connection

See Server connection

General

Save on entry v1.34.0+

By default a button is used to save changed data.

The save on entry option causes all user input to be saved on the server side directly.
Please note: Fields that allow custom input like the Text field, buffer data while the user is typing, but can still cause lots of small data updates, which might not be ideal. Furthermore any data update with the server will block the input during the communication (few milliseconds). This will cause the current field to lose its focus. This behaviour can be turned off with the option Disable while loadingv1.32.0+.

manual saving disabled

Only available with save on entry disabled. If the value of this field is true or -1, the save button will not be clickable, data changes will still cause the icon to light up, but there won't be pulsating.

Back button mode

The back button mode will show a clickable icon that reverts changes made by the user in the current session.

The implementation will simulate a data input with the last value once clicked. The default mode will track changes until the user saves the data. With save on entry enabled, both back button modes track all changes of the session.
Please note: Due to the live update when other users save data, this feature can cause undesired effects if the same data is changed by different users.

Input disabled

If the value of this field is true or -1, all input will be disabled and the input disabled icon will be shown in the Info bar.

Selection disabled

If the value of this field is true or -1, the selection interaction when clicking on a field in a dimension column will be disabled. Selection is still possible with the search of the header (if not disabled as well).

Hide missing license message

By default, if a user connects to the server without a valid license an error message will be displayed. This function will disable the message. The Info bar still indicates that the user has no license though.
Since data is still displayed for non licensed users, this can be common scenario.

Disable copy/paste function

Hovering over a cell and pressing the default button combination (ctrl+c/ctrl+v) will copy/paste the values if possible. This requires a browser focus in the extension. This functionality might be problematic if users want to click in an text field and use the key combination while the mouse is still located above a cell.
Note: Copy/paste is also available via the Context menu

Scroll speed

The scroll speed is handled automatically by default. It will adjust to the maximum of displayed rows, although not exceeding 4 rows per scroll. This can changed to a static value.

Advanced

Overwrite rule execution buffer

The Rule editor can be used to create a complex rule set. This setting will put a cap on subsequent rule executions for one action. This is a safety feature to avoid endless loops, which will crash the browser.
A simple example for such a case would be a rule which triggers itself endlessly.
If your extension runs into the execution cap (a message will be displayed) without actually having an endless loop you can increase the cap here. The maximum value (unlimited) will disable this safety net. Use with caution

Number language v1.32.0+

Determines how field values are parsed to numbers (basically how . and , is handled).

Language

The display language of the extension

Task reload

Enabling either of the following two options requires you to select a task that should be triggered or should have its status shown. You can use the Select task dialog to comfortably search and select your task, or set the task id with a Qlik expression (This can be useful if you work with a test system and want to switch with a variable)

On demand task reload

This will show an clickable icon in the Info bar allowing users to trigger an task. An additional confirmation dialog can be enabled. Furthermore the button can be disable with a value of -1 or true. For example, this can be used to restrict reload access for certain users.
By default a small info will appear if a reload has been triggered.

Task status updates

In the center of the Info bar, the task status can be diplayed. You can choose between different display types, the progress display is based on the last run time of the task.

Create db entry

Generally speaking every new row identifier will create a database entry. To create a more user friendly experience, this setting will show a + button in the Info bar. Once clicked, an additional empty row will be displayed, disabling the input for all other rows. It is still possible to scroll and view the data.
The additional row will create new database id (row identifier). If you have only one identifier dimension, the value will be displayed in that column, all other Qlik columns will have no value, since this row is not based on the Qlik data model.
The button can be disabled with a value of -1 or true.

You can choose from three different Id modes:

• DB id - This will use the next available db_id number. Once the Create db entry button is clicked, the extension asks for the next db_id from the server. Please note: If you have multiple users creating entries at the same time, this can cause insert conflicts, since the db_id is calculated, but not actually created. To avoid this, enable the option Calculate id on insert.
• Formula - The id is based on a Qlik Expression.
• User prompt - The user will be asked for the new id.

Once the additional row is saved, it will disappear from view. By default nothing else will happen, since the newly created database entry is not part of the Qlik data model and therefore not shown in any table. The usual implementation would be to create a Rule that will trigger a task reload once data has been saved or more specifically once a db entry has been created.

Reload performance

The reload time is very dependant on your system and app data model. If you want to improve the reload time, there are some possible solutions:

• Create an underlaying app with the complex data model and access that data via binary load in the actual user app where only the Data+ data is added
• Create QVD files in a generator app, performing much better when loading in the user app
• Use the partial reload functionality where only the Data+ data could be loaded. The task reload Rule allows setting a specific task, making it quite simple to setup different tasks triggers.

You can set default values for Data+ columns in the create entry row. The value can be set in the column setting if the create db entry setting is enabled.

Data loading v1.34.0+

Wait for server data

Wait for server data before rendering. This will improve calculation performance of large data sets. With Extended data handling disabled it should not be used.

Extended data handling

This feature allows loading more data of the Qlik data model than currently displayable. This is limited to 10000 dimension/measure cells (eg. 10 columns x 1000 rows). In case this threshold is exceeded, the feature will disable itself (an error icon will appear in the Info bar) until the data is reduced via selection or an app reload.
Extended data handling enables other features like bulk editing or total value calculation with Rules to apply for all data rather than the displayed only.

Performance mode

Data updates will not check all rows for possible application. This will improve performance for bulk edits drastically, but tables with duplicate row identifier will not work as expected.

All data loading

Remove the 10000 cells limit. Data will be loaded in pagination style.

Auto reload

This can be disabled to avoid automatic data reloads from App reloads or Selection in other Elements. An additional button will be avaible to reload data on demand.

Error icon text

Display text of the error icon for Extended data handling in case the data set is too large and it has been disabled automatically.