Cell settings

A cell is a separated field inside a TRUECHART object that is used to show content such as charts, tables, user interface elements, etc. The following sections explains the general settings that apply for all cells.

General

In TRUECHART, cells are always part of a container. A container can have multiple cells, also called multiple contents. Those multiple content cells are also part of the cell settings.

Cell settings are edited in the settings editor. You can open the settings editor by clicking the cell entry in the right-click or the TRUECHART context menu.

The cell settings are located on the left side menu in the settings editor.

Figure 1. Cell settings menu.

Multiple contents

As mentioned before, every container in TRUECHART can have multiple cells. There is no limitation on how many cells a container can include. However, too many cells may decrease the performance.

The active cell is defined by a condition in the menu. When multiple cells have a condition that returns true, the cell that is higher in the list gets displayed.

The typical use case for multiple cells is the ability to change the visualization on the fly.

Interactions

Interactions define the ability for the user to interact with the cells.

BI selection

Allows the user to select BI values in the BI through the extension. By default the value is active. When disabled a click on a value does not select the value in the BI.

Actions

Besides TRUECHART’s general actions for triggers, the following are also available :

Action	Parameters
Action	Parameters
Next sheet/page	No parameters.
Previous sheet/page	No parameters.
Go to sheet	Sheet id of the sheet to go to; can be entered manually or automatically by using the drop-down list.
Go to story	Story id of the story to go to; can be entered manually or automatically by using the drop-down list.
Go to url	Specify the URL in the Url input box and the target in the Target list. The Mashup only option restricts the action to mashups.
Go to app	Specify the id of the app you'd like to navigate to in the App ID input box and the id of the specific sheet in the Sheet ID input. If you select Email as the target you can further specify an email address, email subject and email body. You can use {0} as a placeholder for the generated link. You can also add a custom text for the link. The link will then show the text as specified. If omitted, it will be inserted at the end of the body. You can also specify the link to be opened in the same, new, custom named window or just be copied to the clipboard. If you use the email option, the email will be generated as an eml file. That way the email can have custom html and allows the option for the individual link. In order to download the eml file, the system administrators have to enable the option to download the generated eml file in the browsers. Currently all browsers handle the download of eml files differently. In general all browsers need to allow downloads. Then either save the eml file or open it directly. It is possible to clear all selections or apply current selections in the target app by checking the corresponding checkboxes. For current selections to work, the currently selected fields/dimensions need to be present in the target app as well. Additionally you can add optional parameters to apply specific selections or a bookmark. Limitations: In "Qlik Sense Desktop" the Email target doesn’t work. Eml files are necessary because direct emails can not handle the sense links correctly Generated eml files are shown as possible bad software by some browsers Links in outlook don’t open selections correctly when using the link directly, to open the links use the copy hyperlink option Fields/Dimensions containing "%" characters, they will not be applied. When importing apps from another system, their ID changes. So, for example, if you designed a target app locally and push it to a server, this action will no longer work since the target app ID has changed. It needs to be manually repaired. This is also the case when publishing.
Share app	Specify the target of an generated link to be shared as email or added to clipboard. If you select Email as the target you can further specify an email address, email subject and email body. You can use {0} as a placeholder for the generated link. You can also add a custom text for the link. The link will then show the text as specified. If omitted, it will be inserted at the end of the body. If you use the email option, the email will be generated as an eml file. That way the email can have custom html and allows the option for the individual link. In order to download the eml file, the system administrators have to enable the option to download the generated eml file in the browsers. Currently all browsers handle the download of eml files differently. In general all browsers need to allow downloads. Then either save the eml file or open it directly. Target clipboard adds the generated link to the clipboard and shows a message to the user. Field selections The current selection is included in the generated URL. Note however that too many selections can heavily impact the performance of opening the sheet. Especially if the parameters are in square brackets → `.../select/Sales/[2%2C12];[2%2C97]/` If your URL contains such values, we suggest to use no more than 10 selections. Limitations: In "Qlik Sense Desktop" the Email target doesn’t work. In mashup/story mode the URL can’t be properly generated. Eml files are necessary because direct emails can not handle the sense links correctly Generated eml files are shown as possible bad software by some browsers Limitations of field selections: Links in Outlook don’t open selections correctly when using the link directly, to open the links use the copy hyperlink option. If you have a selection for a field that is a formula like `=Round(Sales)`, the sheet won't load. No more than 100 values can be selected for a field The URL will not be longer than 2000 characters. See https://stackoverflow.com/a/417184

Sense

Action	Parameters
Set variable	Specify the variable and value to be set in the Sense variable and Variable content input box. The Keep option keeps the value unchanged if it's already set.
Select value(s)	Select the field and value(s) in the Field name and Value(s) input box. The Toggle option will toggle between selected states. The Soft lock option sets locked selections to be overridden. The Keep option sets existing selections for the selected field to remain unchanged. The Add option sets the values to be added to the existing selection.
Select match	Specify the field to be selected and value(s) in the Field name and Value(s) input box. The Soft lock option sets locked selections to be overridden. The Keep option sets existing selections for the selected field to remain unchanged.
Select alternative	Specify the field to be selected in the Field name input box. The Soft lock option sets locked selections to be overridden.
Toggle selection	Specify the field to be selected in the Field name input box. The Soft lock option sets locked selections to be overridden.
Select possible	Specify the field to be selected in the Field name input box. The Soft lock option sets locked selections to be overridden.
Select all	Specify the field to be selected in the Field name input box. The Soft lock option sets locked selections to be overridden.
Selection backward	No parameters.
Selection forward	No parameters.
Clear field	Select the field to be cleared in the Field name input box.
Clear other	Select the field in the Field name input box. The Soft lock option sets locked selections to be overridden.
Clear all	Set the Locked also option to also clear locked selections.
Lock field	Select the field in the Field name input box.
Lock all	Set the Locked also option to also clear locked selections.
Unlock field	Select the field in the Field name input box.
Unlock all	No parameters.
Apply bookmark	Bookmark id which can be entered manually or automatically by using the drop-down list.
Reload data	Set the desired mode in the Mode list. Set the Partial option to do only a partial reload.

Caution

The Reload data action should be used with extreme care as reloading the app triggers a sheet reload which can result in the complete loss of unsaved comments on this sheet. Additionally, in the case of published apps, it is necessary to create a corresponding Security Rule on the Qlik Sense server. Security Rule configuration hints for this reload action can be found here: Enable the reload action for published apps

Style

Style settings are unique for every cell. By default, most cells behave in a way so they don’t interrupt the styling of the parent cells.

Horizontal

When enough space is available in the cell, the cell content can be positioned to the left, centered or to the right of the cell.

Vertical

When enough space is available in the cell, the chart can be positioned at the top, center or bottom of the cell.

Scrollbars

This setting activates or deactivates scrollbars for the cell. This can be useful when a chart just barely fits into a container and scrollbars are visible but there is nothing to scroll.

Margin, border and padding

You can define margin, padding and border for a cell. Every setting can be unique for each side of the cell or you can set them once as a uniform which effects all sides. Borders can also define a color.

Figure 3. Margin, padding and border settings.

Background

A cell can have a unique background. You can set an image or a color and place the background at certain positions.

When a cell is part of a grid, it has a higher priority than the underlying grid cell itself. That means, the cell in the foreground shows the background above the grid cell’s background.

Figure 4. A cell with a grid and different backgrounds.

TRUECHART knowledge base