Properties

Dimensions To add a dimension to your table, click on Add dimension and select a dimension from the list.

  • Field: Please see Qlik Sense Table properties documentation.

  • Label: Please see Qlik Sense Table properties documentation.

  • Dimension: Only displayed for master items. Please see Qlik Sense Table properties documentation.

  • Include null values: Please see Qlik Sense Table properties documentation.

  • Limitation: Please see Qlik Sense Table properties documentation.

  • Column width: Drag the slider handle horizontally to adjust the column width in pixels

  • Custom column width: Enter a number to set a custom width for the column. You can also use an expression to set the number. Click fx to open the expression editor.

  • Allow sorting: Enable or disable sorting on individual columns. You may disable sorting for all dimensions globally under Table > Allow sorting.

  • Commentary details view: Display column in row-detail table shown when a comment for a specific row is selected.

Measures

To add a measure to your table, click on Add measure to open a list of available measures. Select the measure that you want to use. If you select a field, you are automatically presented with some common aggregation functions that you can choose between for the measure.

  • Measure: Please see Qlik Sense Table properties documentation.

  • Expression: Please see Qlik Sense Table properties documentation.

  • Label: Please see Qlik Sense Table properties documentation.

  • Number formatting: Please see Qlik Sense Table properties documentation.

  • Column width: Drag the slider handle horizontally to adjust the column width in pixels.

  • Custom column width: Enter a number to set a custom width for the column. You can also use an expression to set the number. Click fx to open the expression editor.

  • Commentary details view: Display column in row-detail table shown when a comment for a specific row is selected.

Sorting Please see Qlik Sense Table properties documentation.

Table

  • Table layout: Determines how the table will manage column widths for the overall table layout. The following formats are available: 1. Horizontal scrollbar: Widths are fixed for each column and a horizontal scrollbar is enabled if the total number of columns exceed the available table width. 2. Fit in view: Column widths are auto-calculated and distributed equally amongst the available table width.

  • Allow sorting: Enable or disable sorting in all dimension columns.

Comments

Table commenting is a powerful feature which allows application users to share insights and feedback on individual rows, based on the current selection state and their permission level.

  • Display last comment: If enabled, it will display the last comment entered on the Comments column cells. Disabling this feature would only display the total number of comments per row.

  • Column width: Drag the slider handle horizontally to adjust the column width in pixels.

  • Custom column width: Enter a number to set a custom width for the column. You can also use an expression to set the number. Click fx to open the expression editor.

  • Colors: Customizes cell colors for the Comments column, overriding the default theme colors. The following options are available: 1. Auto: Default theme colors are applied. 2. Custom: Choose custom background and text colors for the Comments column.

  • Enable profile photos: If enabled, each individual comment will display user profile photos (if available). 1. Content Library name: Choose from a list of Qlik Sense content library names where images are stored. You will need to previously upload pictures to a content library folder. Images must be in JPG format and file must follow a specific naming convention, where the file name represents the Qlik Sense user ID, e.g. jsmith.jpg 2. Profile photo shape: Customize the way that profile photos are displayed by choosing amongst 3 different user profile photo shapes.

Appearance

  • General: Please see Qlik Sense Table properties documentation.

  • Alternate states: Please see Qlik Sense Table properties documentation.

  • Header o Background color: 1. Pick a custom color for the table header background 2. Font color: Pick a custom color for the table header font text 3. Horizontal alignment: Choose if the header column title should be left, center or right aligned.

  • Rows: Enable if you would like the table cell text to wrap into multiple lines. Unchecking this option would display text in a single line and hide any overflowing content.

  • Totals 1. Display totals row: Show or hide the Totals row 2. Label: Add a custom label or click the fx icon to open the Expressions editor 3. Background color: Pick a custom color for the table Totals background 4. Font color: Pick a custom color for the table Totals font text

Known limitations

  • There’s a current limitation when converting any object into a Qommentary Table extension which causes invalid table rendering when adding or removing columns.

  • Table does not render properly in full screen.

  • Approval workflows cannot be applied to row comments. This feature will be available in future releases.

Last updated