TABLE OF CONTENTS
- Dimensions and measures sort order
- Sort selected items first
- Allow collapse
- Export data set title
- Mashup Export URL
- Zero values on/off as default
- Override include null values
- Defer Layout Update
- Selection Settings
- Trellis Settings
- Analytic Search Settings
Dimensions and measures sort order
This setting will decide how the lists with dimensions and measures are sorted.
"Sort alphabetical" will sort ascending in alphabetical order. This is the default.
"Sort by data set order" follows the order the dimensions and measures are placed in the table starting from the left if this is a table data set (created from a native Qlik Sense Table). For normal data sets (created with the Data Set Creator) the order will go from top to bottom. If a special sort order is needed this is the easiest way to achieve that.
Sort selected items first
This will move all selected items in dimensions and measures to the top. The advantage is that no selected items are "hidden" in the lower part of the list.
When activated, the Custom Report will show only a title once the collapse size is reached. Collapse will happen when the min width OR min height is reached.
Export data set title
The data set title will be included in the export when the option is activated.
Mashup Export URL
When used in mash-ups it is typically required to change the export URL in order for the export to function as expected. Only change this if you understand how the extension will behave in a mashup.
Zero values on/off as default
This will set the default for zero values on/off. User can still change this in the extension from the context menu (unless visualization settings are hidden from the context menu).
Override include null values
This will override the setting from the master item table on including null values or not. Similarly for normal data sets it will override the measure setting for including null values. This setting can sometimes be useful in pivot-tables when excluding null values on sub-dimensions can cause unwanted (but correct) results.
Defer Layout Update
This feature is essential when working with larger data sets since it limits the amount of times the values need to be recalculated. Enabling defer layout update will hold an update until the Update layout button is clicked (Figure 1). The user can then make several selections in quick succession without having to wait for the data set to refresh.
Figure 1: Update Layout
Selection Settings are found in the Settings section in the property panel (Figure 2).
Figure 2: Selection Settings
Figure 3: Allow Selections
The Selection Bar shows (or hides) the small bar at the bottom of the dimension (Figure 4).
Figure 4: Selection Bar
Trellis Settings control the display for Trellis Mode (Figure 5). When it's enabled you can set the default sheet size and the maximum available number of objects in a sheet.
Figure 5: Trellis Settings
Analytic Search Settings
There is a separate section on Analytic Search found here.