Configuring the load script

You can configure the Qlik Sense app load script app for Qlik Big Data Index with script variables.

You can disable some Qlik Sense functions that are not supported in Qlik Big Data Index. You can add the variable in the data load script.

Disabling sorting in charts

Sorting is enabled on all new columns by default in Qlik Sense. This can create performance issues when developing a Qlik Big Data Index live mode app as it will take time to sort a field with many records.

You can disable sorting in charts by creating a variable named QABDI_DisableSortingInCharts with the value 1.

We recommend that you use the following work flow when developing an app:

1. Add the variable to the load script.

   SET QABDI_DisableSortingInCharts=1;

2. Reload the app.

   Sorting is now disabled for all charts.

3. Add charts to the app. When you add a chart, disable sorting for all columns where you do not need sorting.
4. Return to the load script and delete or comment out the line with QABDI_DisableSortingInCharts.
5. Reload the app.

The app is now sorted on the columns you choose to not disable sorting on.

Disabling evaluation of charts that do not have a measure

When creating a chart, the evaluation and drawing of some charts without a measure is disabled. This is to save time by avoiding drawing a half finished chart which can take some time with a large data set.

You can use the QABDI_ChartTypesToOnlyEvaluateWithMeasures variable to control which chart types that should have this behavior.

The default setting is:

SET QABDI_ChartTypesToOnlyEvaluateWithMeasures='barchart; linechart; piechart; table; qlik-barplus-chart; qlik-bullet-chart; qlik-funnel-chart-ext; qlik-heatmap-chart; qlik-radar-chart; qlik-sankey-chart-ext; qlik-smart-pivot';

You can edit the list. For example, you can remove table, and tables are drawn even if you do not have a measure.