1. Introduction

The trueChart Feature Guide covers all the features of the trueChart extension for Qlik Sense®. In the following sections, you will get an overview and detailed instructions on the following topics:

1.1. Qlik Sense Support

trueChart is suitable for the Qlik Sense version 3.0 and higher. The latest version of Qlik Sense, June 2018 has been intensively tested and is supported explicitly from trueChart version 2018.2.x onwards.

1.1.1. Export

The standard export (image, pdf, pptx) of trueChart from v2018.2.x by Qlik Sense is fully supported.

1.1.2. Qlik Sense Mobile

Online mode is supported by trueChart. (look at known issues for dynamic host names in Release Notes)

Offline mode is current not supported by trueChart.

1.2. Printing & Export Support

trueChart from v2018.2.5 fully supports nPrinting June 2018.

trueChart fully supports image and additional text export, especially for comments, with external partner solution Mail&Deploy. For more information on the Mail&Deploy export solution, click here: http://www.mail-and-deploy.com.

1.3. Prerequisites

It is assumed that trueChart is already installed. If not, consult the trueChart Installation Guide to get a detailed explanation of the installation process.

Furthermore, users must be created in order for the trueChart extension to communicate with the trueChart service. If you need help, consider reading the trueChart Service Guide.

2. What is new in trueChart v2018.2.8?

App sharing

With trueChart 2018.2.8 we offer great possibilities to give users uncomplicated access to the current analysis status of your app. With the new' Share app' button action, you can easily distribute a link to the current worksheet and selection via clipboard or email to interested users. Further information can be found here: Button actions 'Navigation'.

Document chaining

As a professional add-on, the new' Go to app' button action can be used to create efficient navigation chains within the same or across different apps. Within this, existing selections can be simply "taken along" into the other app. In addition, new selections can be added or overwritten or bookmarks can be applied. Further information can be found here: Button actions 'Navigation'.

Responsive chart & font sizes

Chart and font sizes are now automatically adjusted depending on the width of the browser. This is also advantageous when exporting as PDF. Further information can be found here: Notation Manual Text Settings.

Commenting

Perspective comments can now be deleted by clicking on the corresponding icon. Further information can be found here: Editing perspective comments.

2.1. Migration for published apps

In the context of new versions, necessary adjustments within the apps are usually carried out automatically during loading. This is transparent for the users. An indication of this are corresponding logging entries in the development console of the browser.

Since changes to published apps cannot be saved, these automatic changes must be made at every load, which can have a negative effect on the loading speed of the visualization.

To avoid permanent migrations of the apps, we therefore recommend opening the corresponding apps as soon as possible in an unpublished mode, so that migration is then performed once and the changes are saved automatically. These apps should then be published again.

3. Extension properties panel

Upon creation of a new trueChart extension in your sheet, i.e. dragging it from the Extensions pane to your sheet, you need to set up the basic properties in the properties panel of Qlik Sense®.

Creating a new extension in your sheet
Figure 1. Creating a new trueChart extension from the Extensions assets panel (1) will unveil trueChart’s properties panel (2).

Additionally, the properties panel can be accessed anytime in the sheet’s Edit mode. There are four panes available:

  • Data – set up data contexts, i.e. dimensions–measures relations, for later use.

  • Sorting – define the sorting applied on the context selected in the Data pane.

  • Add-ons set properties for data handling.

  • Appearance – specify name and titles for the extension and set the spacing around the content.

The meaning of each of these is explained in the subsequent sections.

3.1. Data

The Data pane allows you to set the data context for later use in trueChart. It includes three primary sections:

3.1.1. Data contexts

properties data fs8
Figure 2. The Data section from the properties panel.

The Data Context section allows you to create multiple sets of dimensions and measures. To create a new data context, press the Add Data Context button, and rename the new context in the context title box. trueChart does not require a specific naming convention, but the name should be descriptive, and follow a logical formatting pattern. To remove a data context, select the context from the dropdown box and press Remove Data Context.

3.1.2. Dimensions

The Dimensions property is where the developer defines the chart’s dimensions, the qualitative data. To create a new dimension, click the Add button, and select the desired dimension from the list of fields, or type part of the name in the search box, to filter the list, and then select the dimension from the search results. Alternately, you can create a dynamic dimension by pressing the fx button and typing in an expression.

2 1 Dimensions
Figure 3. Adding dimensions to a new trueChart extenstion.

3.1.3. Measures

The Measures property is where the developer defines the chart’s measures expressions, to aggregate the quantitative data. To create a new measure, click the Add button, select the desired dimension from the list of fields, or type part of the name in the search box, to filter the list, and then select the measure from the search results. Then, select the appropriate aggregation. By default, the measure will be labeled / named the same as its expression. To change the name, click the arrow to the left of the name, to open the measure’s properties, and change the label value. TrueChart does not require a specific naming convention, but it should be descriptive and follow a logical formatting pattern.

3 1 Measures Expression

Similarly to Microsoft Excel, Qlik Sense will try to get the best results. To specify the format, click the number formatting dropdown box, and select the appropriate format style for your data.

3.1.4. Additional options

Dynamic label

To have the label changed dynamically.

Relative

Check the Relative box to enable relative values.

Accumulation

By default, your data will not be accumulated.

Delete

To delete a measure, click the Delete button.

3.2. Sorting

Sorting
Figure 4. The Sorting pane of trueChart’s properties panel.

The dimensions and measures are sorted in the order they were added and each dimension is sorted internally. To rearrange the sort order, drag the dimension or the measure vertically, until they are in the desired order. To change the default internal sorting, click on the dimension or the measure name to open the settings button and switch to Custom sorting. There are three internal sorting options:

  1. By expression: Only available for dimensions. Enter an expression to sort by, for example: Max(Sort_Id)

  2. Numerically

  3. Alphabetically

The sorting is either Ascending or Descending.

3.3. Add-ons

properties addons
Figure 5. The Add-ons pane of trueChart’s properties panel.

3.3.1. Calculation condition

Specify an expression in this text field to set a condition that needs to be fulfilled (true) for the object to be displayed. For example:  count (month) = 1 If the condition is not fulfilled, the message in the text box Displayed message is shown.

3.4. Appearance

3.4.1. General

The Appearance pane in the properties panel features two sections:

In the General section you can set the Title for this specific trueChart extension and whether it’s to be shown by toggling the Show titles switch. Additionally, you can set a Subtitle and Footnote when Show titles is switched to On.

Alt
Figure 6. Setting the title, subtitle and footnote in the Appearance section.

By default, the string is interpreted as a text string. However, you can also use the text field for an expression, or a combination of text and expression. An equals sign (=), at the beginning of a string shows that it contains an expression.

3.4.2. Position Adjustment

The second section, Position adjustment, is for adjusting trueChart’s content inside its boundary box. By default, the padding for all four edges are set to Automatic. By switching them to Custom, you will be able to set individual paddings in pixels.

image
Figure 7. Setting a custom padding for the top of the extension.

3.4.3. Display

In the Display section, you can set the visibility of the Sense snapshot and maximize button. The elements can be permanently hidden (Hide), shown (Show = default setting) or displayed depending on an expression.

display_prop
Figure 8. Define visibility of Sense snapshot and maximize button.

4. Right-click menu

The trueChart extension, including all of its visualizations, is controlled by the right-click menu.

rightclickmenu
Figure 9. Right-clicking on the trueChart extension will open the right-click menu.
  • trueChart will extend the advanced right-click menu:

    • Scaling contains actions to fixate the scaling of scaling groups:

      • Fixate all locks the scaling of all scaling groups at the current value.

      • Fixate group locks the scaling of a specific scaling group at the current value.

      • Variable, Add adds the value at the mouse cursor as a variable.

      • Highlight lets you create new or edit/delete existing highlights on the chart,

      • Compare lets you create new or edit/delete existing compares on the chart,

      • Input, Save changed will save the inline comments of the extension.

      • Cell includes all actions that change the contents of a grid cell.

        • Content will open the cell dialog.

        • Table opens the table dialog to configure a table.

        • Link lets you create links between axes, legends and values of different charts.

        • Cut cuts the current cell content and stores it in the clipboard.

        • Copy copies the current cell content into the clipboard.

        • Paste pastes the cell contents in the clipboard into the given cell.

      • Layout leads you to the layout editor.

      • Context will open the data context dialog.

      • Object contains all the actions to save, load, or export the extension:

        • Save saves the state of the extension.

        • Initialize sets the state of the extension to default.

        • Export as Image exports the extension in a PNG file.

        • Export as PDF exports the extension in a PDF file.

        • Export as Vector Graphic exports the extension in an EMF file.

        • Export as Excel exports the extension in an Excel sheet.

        • Deactivate Drilldown supresses the automatic drilldown behavior when clicking on a data element.

      • Overall contains general and Notation Manual settings:

      • Edit Text switches between edit and show mode.

      • Help & About opens the Help & About dialog.

  • Save input will save the inline comments of the extension.

  • Cell will open the cell dialog for the specified cell.

  • Layout leads you to the layout editor.

  • Context will open the data context dialog.

  • Save object will save the state of the extension.

  • Show Text and Edit Text will toggle between the show and edit mode.

5. Data context

A data context is a defined set of dimensions combined with a defined set of measures calculated based on these dimensions. trueChart supports the use of multiple contexts. These can be defined in the Context section located within the properties panel of the trueChart extension. The context dialog is available by right-clicking on the trueChart extension and selecting Context.

5.1. Dimensions, Keyfigures

Shows a list of available Dimensions and Keyfigures within the selected context. The context can be selected from the dropdown menu located right below the respective tab. The minus '-' and plus '+' signs in each respective section allow for either a dimension or a keyfigure to be added or deleted. A keyfigure defined in this section will be exclusive to trueChart and will not show in the extension property panel.

5.1.1. Dimensions

The Dimensions list in the Context dialog features all the defined dimensions for the selected context.

image
Figure 10. Selecting a dimension from the Dimensions list will open the dimension properties dialog.

Selecting any dimension will open the dimension dialog allowing you to undertake settings in the following tabs:

  • General – general settings such as name and the inclusion of Null Dimensions

  • Time – set the formatting of time and date values

  • Sorting – apply expression-based sorting behavior

  • Additions – create additional categories such as First, Rest, or Total.

General
image
Figure 11. The General tab inside the dimension properties dialog for a selected dimension.
Type

If you have added a dynamic dimension you are able to choose if the dimension is treated as a normal or a dynamic dimension.

Name

Default option is that trueChart uses the name of the dimension as it is defined in the extension’s properties panel, but if you click on the little icon above the right text box you are able to define a new name for that dimension that is not related to the name coming from QlikSense.

Null Dimension

By checking this checkbox, you enable this dimension to be available even if its content is NULL.

Time
image
Figure 12. The Time tab inside the dimension properties dialog for a selected dimension.

If the selected dimension contains time based values, you can configure the type of time based value that is stored in the dimension and define how the formatting of the time based dimension should look like in a chart object. This feature works best if the input dimension is formatted as YYYYMMDD. You can even use a formatting function to get the format correct when setting up the dimension in the extension properties panel.

Sorting
context sorting
Figure 13. The Sorting tab inside the dimension properties dialog for a selected dimension.

Basic sorting can be done by using the the configuration of trueChart’s properties panel. This section is to define a more specific sorting setup.

Condition

This field is used to define when the configured sorting will actually take place. Sorting will only take place if the condition evaluates to true.

Order

Based on your dropdown selection the dimension will be sorted from top-down or bottom-up.

Type and value

Those two properties are tied together. Value defines how many items will be shown. Type defines if only the first n or the first n% will be shown. For example, type n and value 10 will only show the top or bottom 10 values while type % and value 10 will only show the top or bottom 10% of all entries.

Target

This dropdown selects the keyfigure to determine the sorting.

Additions
image
Figure 14. The Sorting tab inside the dimension properties dialog for a selected dimension.
First

You can define a name for the first entry in the sorted dataset. You can decide if the name is taken from Qlik Sense if you have defined it in the properties panel. Therefore you have to check the BI checkbox. Or you can uncheck the checkbox and specify a name in trueChart.

Rest

If you are using the sorting feature and decide to only show top or botton n entries the other entries will be shown together as one entry Rest. If you have defined the sorting in the properties panel you can use the BI checkbox. By that the rest entry will have the name that was defined in Qlik Sense. Otherwise you can type in any name you want to define an individual name for your rest. The Order icon defines where to show the rest entry. You can choose between top and bottom or to sort it within the dimensions sort logic.

Total

If you choose to show a total you can check the BI checkbox to take the totals name from Qlik Sense (if you have defined to show the total in the side panel) or uncheck the checkbox give the total an individual name. If you have unchecked the BI checkbox you can furthermore decide to check the category checkbox. If you have done so, the total will be named based on the dimensions category. By using the order icon you can decide if you want to show the total on top or on bottom of the chart. The Hierarchy checkbox allows you to show the category only once at the beginning of a group.

5.1.2. Keyfigures

The Keyfigures list in the Dimensions, Keyfigures tab of the Context dialog contains all the keyfigures (i.e. both those from BI software as well as user-defined ones) defined for the given context.

context keyfigures
Figure 15. Selecting a keyfigure from the Keyfigures list will open the keyfigure properties dialog.

User-defined keyfigures can be added and deleted by using the + and icons respectivly. By selecting a keyfigure, it’s possible to make adjustments and apply several induvidual settings to it in the keyfigures dialog:

  • General – apply general settings, such as name and Scaling group

  • Data Rules – apply Data Rules

  • Expression – (only available for user-defined keyfigures)

General

By default, the keyfigures’ names are inherited form the context definiton in the properties panel. By unchecking BI-Name, you can also define individual keyfigure names, that can be edited in the trueChart Name textbox.

It’s possible to have multi-row labels. trueChart also combines labes over several keyfigure labels as long they have the same spelling on the same row:

image
Scaling group

Determine the scaling group of the keyfigure. A scaling group is responsible for the same area usage when visualizing for all values of all keyfigures for a perspective. A scaling group could be named „USD“ or „EUR“ for example. The determination of „same scaling group“ is based on the same kind of „string“. A difference of one digit makes for different scaling. A scaling group can be defined dynamicaly by entering a variable. Example: $(vScaling_Group1) Already used scaling groups  in the same Qlik Sense Sheet in any trueChart object can be reused by selcting them over the pulldown menu.

Also empty scaling group is a valid group. Therefore all keyfigures with an empty scaling group will be scaled the same way.

Data Rules

The Data Rules tab allows for creating and adjusting data rules for a specific keyfigure.

image
Figure 16. The Data rules tab showing the Rule sub-tab.

The dialog is sub-divided into four tabs:

Rule
image
Name

Determine the name of the Data Rule To add Rule click the '+' sign on the right side of an existing rule. To remove a Rule click the '-' sign on the right side of the rule which should be removed

Applies to

Filter data for this rule using category entities. A value in Applies to is mandatory, true makes the rule active for all category entities.

Example: The rule for the months January-June: $(DIMENSION,POSITION)>=1 AND $(DIMENSION,POSITION)⇐6

Condition

Filter the data for this rule using values. A value in Condition is mandatory, true makes the rule active for all category entities.

Example The rule is active for all values greater 100: $(K01; AC)>100

Copy from…

It’s possible to copy Data Rules from other keyfigures.

Overall
context datarules overall
Keyfigure

Determine the type of the Keyfigure. This results in different category width. The width of each type is defined in the notation manual: Amount, Quantity, Relation.

Value

Determine if the value is a normal value, a total or a subtotal.

Factor

The displayed value is divided by this factor.

Decimals

The number of decimal places used for drawing.

Unit

The unit of the keyfigure, for example Euro or liter. The unit is displayed only, if it is activated at Keyfigures/Overall in the Cell menu.

Rating

Turns around the meaning of positive and negative values. The two color schemes are exchanged.

Signs

Changes the sign of the keyfigure.

Base
context datarules base
Time

Relation of the keyfiure: Past,Past, Past, Present, Future.

Type

Determines the meaning of the keyfigure: Actual (real existing values), Budget (planned values), and Forecast (estimated values).

Version

Choose a scenario, that is stored for Actual, Budget or Forecast in the notation manual. Different scenarios contain different visualization options.

Delta

Activate this option to draw positive and negative values in different colors. The colors are defined in current scenario of the notation manual.

Individual

Standard colors are retrieved fom the current scenario in the notation manual. Activate this option to allow individual colors. The colors can be set be a RGB value individual for the boarder, pattern and background.

Reference
context datarules reference

References can be used to viszualize the delta according the base. If set to Active, the values for Time, Type, Version, Delta and Individual are used as a reference for keyfigures set as delta. This reference may be shown on the axis of the cell.

Expression
context expression
Applies to

Filter data for this formula using category entities.

Example

The formula for the months January-June: $(DIMENSION,POSITION)>=1 AND $(DIMENSION,POSITION)⇐6 A value in Applies to is mandatory, true makes the formula active for all category entities.

Formula

If the KPI was created in trueChart, a Formula may be added.

Calculation

Determines the Calculation of the value entities

  • Summation: The current value from BI-Software is used.

  • Cumulation: The sum of the current and all former values. Cumulation continues, until a formula with summation occurs. The cumulation is resetted and starts from zero.

5.2. Variables

image
Figure 17. The Variables tab of the Data context dialog.

trueChart allows Qlik variables to be used within specific parts of the extension. These variables are evaluated by trueChart and the result is displayed in this tab. trueChart only evaluates the required variables used within the extension currently visible on the sheet. These variables are marked with a tick in the first column of the variables list.

5.3. HiCo Variables

HiCo Variables are defined within trueChart. These variables may be used for functionalities such as commenting and if available will show in this list.

6. Layout editor

The layout of a trueChart extension can be changed and extended using the Layout editor. Per default, every new trueChart extension consists of a 1×1 grid with A1 as the only cell.

6.1. Orienting yourself using the breadcrumb bar

When editing a grid, a breadcrumb bar is displayed at the top that illustrates the hierarchical structure of the extension’s layout:

layout breadcrumb

It also features the opacity button that will let you change the opacity of the grid editor on the underlying content and the OK and Cancel buttons to close the Layout editor.

6.2. Root cell properties

The root cell is the cell that spans the grid layout and offers the following settings:

6.2.1. Borders & Padding

By clicking on Borders & Padding you can set border color, border width and padding for each of the four edges.

By using the Uniform option, you can define border and padding for all edges at once.

The Prevent scrolling option will prevent the extension to scroll in any direction if the content spans over its boundaries.

layout borderpadding

6.2.2. Width and Height settings

Here you can set the width or height for the root cell in Percent or Pixel as well as a minimum width or height in pixels.

The Content-based optimization will try to extend the cell’s size so it fits its contents.

layout widthheight

6.3. Grid properties

When clicking on a grid or the Edit grid button, a spreadsheet-like header is shown to indicate the cells:

layout spreadsheet

By clicking on a specific header indicator, you can extend or decrease the grid horizontally or vertically respectivly and set its dimensions in relation to the parent cell similar to the width and height settings for a cell:

layout columnsettings

Besides Percent and Pixel, you can also define the dimension by using a Weight indication so you’ll be able to define relational cell sizes like 1:3, 1:2:3, 1:1:3, etc.

6.4. Cell properties

By clicking on a specific cell, you will enter the cell mode that provides you the following settings:

6.4.1. Setting a distinctive cell name

By clicking on the icon next to the cell name, you can change it to a custom name:

layout customcellname

6.4.2. Setting the cell type

By clicking on Cell type, you’ll be able to set the content of the cell, i.e. either Empty, Grid (to create nested grids) or Extended (a trueChart content type such as a chart or table).

layout celltype

6.4.3. Border & Padding

The Border & Padding setting of a cell is the same as for the root cell.

6.4.4. Copying cells

The outermost right tab provides functions to cut or copy cells by clicking on Cut cell or Copy cell respectivly. The Styling and Content checkboxes define if the styling and content information should be included when cutting or copying.

layout copycell

7. Cells

A cell is a separated field inside a trueChart extension that is used to show content such as charts, tables, user interface elements, etc. The following sections explain the different cell types as well as their settings in detail.

7.1. Single

The Single type is one of the six available cell types and contains either a chart (time chart or structure chart) or a table.

celltypes single

The Single type features a list of cases for each of which a Condition must be defined. The first case in the list for which the condition evaluates to true is eventually selected. This is indicated by the blue square next to the Condition field.  By default, every new Single is set up with one case the condition of which is set to true.

The Context list is to select the data context used for the visualization and contains all the contexts used in the current sheet, preceded by the name of the trueChart extension the context has been defined for.

celltypes single contextselection

Type features three icons from which you can choose the type of visualization, i.e. structure chart, table or time chart.

celltypes single types

Under Alignment you can set the alignment of the visualization inside its cell for both Categories direction and Elements direction. The actual direction (horizontally or vertically) is determined by the chosen Type.

celltypes single alignment

The Table dialog button is only active for the table type and will take you to the table settings.

celltypes single tabledialog 1

Further settings on how to display the categories and keyfigures are provided in the Categories and Keyfigures tabs.

7.1.1. Categories

celltypes single categories overall

The Categories tab features all the settings associated with the handling and rendering of the chart’s dimensions.

Overall

In the Overall tab you can set the basic properties of a category explained in the following sections.

Overall tab
Figure 18. The Overall section of the Categories tab in the cell dialog.
Show at

Defines the position of the Dimension. You have the following options:

  • - :                                 Hides the Dimension entities

  • Axis:                            Shows all Dimension elements below the Chart

  • *Free Axis Position:*    Dimension entities showed at free position

Allignment

Choose the allignment of the Dimension enteties. Possible allignments:

  • *Vertically:*       Top/Bottomimage

  • *Horizontally:*  Left/Middle/Right image

Labels without totals

Determins if a Dimension entity should use an extra line at a control break, even if there is no sum for this group. Options: Collapsed/Uncollapsed

Additional width

Define additional with to the normal distance between the Dimension entities.Scaling  in millimeters/10pt.

Distance multiplier

The distance multipier doubles or tripples the distance between the categories according to the position of the elements. The more positions you use, the greater the distance.

Dimension configuration
Applies to

Filters data for specific rules, using category entities. Default value is "true".
Example: Rule for months January - July: $(DIMENSION,POSITION) >=1 AND $(DIMENSION,POSITION) ⇐ 6

Condition

Filters data for specific rules, using values. Default value is "true".
Example: Rule for all values greater than 100: $([K01]; AC) > 100

Cut at

Defines the maximal lengh of a category entity. Scaling  in millimeters/10pt. If there is not enough space for for the entity description, it will be cut off and ended with three dots.

Separator
celltypes single categories separator
Reference

Determines which keyfigures should be used for the generation of separators.

Change of

Defines which change in the keyfigure should generate a separator. Options are changes in:

  • Time type

  • Scenario

  • Category

Length

Configuration of the Length of the separator. Configurations can be adjusted at the Start and the End of a Category. Default value is Auto. Manual adjustments can be defined for following types:

  • Change of (reference values)

  • Subtotal

  • Total

  • Total without values

Gap

In the Gap tab you have the option to define a gap between the chart and its dimension entities. This function can be used for a seperate entity or keyfigure, related to the dimension, such as Forecast or Total.

celltypes single categories gap

To add a new gap you have to click on the + in the top right corner or copy an existing configuration via the Copy from…​ - Button. Then you can define the following characteristics of the gap:

Applies to

Defines a rule for which cases the gap will be implemented. Default value is true. In this case the defined gap will be implemented for all dimension entities. Example for a rule only for Total: $(DIMENSION, TTL)==true

mm/10pt

Defines the distance of the gap in mm/10pt.

Position

Sets the position of the gap. The gap can be either at the end or at the start of an entity.

Split axis

Activate this option to leave a gap between the main dimension’s axis and the defined entities in Applies to.

7.1.2. Keyfigures

Element

In the Element tab under Keyfigures, you can define the basic visualization of a chart or table.

It features a list of all the keyfigures available in the defined data context as indicated in the Keyfigures column.

Show as

The Show as list contains all the applicable keyfigure visualizations, i.e. Value, Bar, Needle, Waterfall, Line, and Symbol, as indicated by following illustration:

celltypes single showas

Additionally, there is ‒ (dash) to disable the visualization of the particular keyfigure at all as well as List, Comment and Flag to define input fields in tables.

Starting at

Using the Starting at setting, you can define if the values of a keyfigure should start at the axis or at the value of another keyfigure. In the latter case, the element is drawn at runtime at the height of current keyfigure value.

Position

The Position setting allows you to set the position of an element within the category. To every position exists at least one frame position. A frame position’s orientation depends on possible bars or waterfalls. Therefore, a frame position can not be a bar or a waterfall itself. The following positions can be set:

Mid

This is the standard position. The elements position is in the middle of position left and right and has two frame position, mid-left and mid right.

Left, top

The position before the middle element. In a time chart it is left, in a structure chart on top. The frame position is left-left or top-top.

Right, bottom

The position after the middle element. In a time chart it is right, in a structure chart on the bottom. The frame position is right-right or top-top.

Stack

The Stack setting determines the order of the current keyfigure in a stack. In time charts, the bars are ordered upwards, in structure charts from left to right using the numbers from 0–9.

A key figure for each stack needs to be prepared in advance in the Right-click menu. It is not possible to derive different stacks from a dimension field due to IBCS visualization rules. For visualizations of dimensions with more than ten entries use multiples (Cell → Content → Type → Multiple)

Order

The Order setting determines the drawing order of the elements for a position. Lower numbers are drawn first.

Example

If you want to draw a fill-level, you set the fill value to the number 1 and the maximum fill level to number 2.

Notation

The Notation list provides different ways of displaying the keyfigure’s meaning, specified in its data rules. Depending on the type of keyfigure visualization, you can apply the meaning to:

Element

The visualization concept of the base datatype affects the element, e.g. a bar.

Header

The visualization concept of the base datatype affects the header of the table.

Axis

The visualization concept of the base datatype affects the axis.

Element-Header

additional to element notation the table header is affected by the reference visualization concept..

Element-Axis

Additional to the element notation, the axis is affected by the reference visualization concept.

Concept

The Concept list (only for tables) is used to define one of the visualization concepts Area, Color, and Shape, or combinations of them for the element, dependent on the time type and the scenario (actual, budget, forecast) in the notation manual.

Base and Reference
Axis mid

In table visualizations, the Axis mid option will force the axis of graphical representation to be centered in the column instead of automatically adjusted based on the min–max span.

celltypes single keyfigures element axismid
Description
celltypes single keyfigures description
Outlier
celltypes single keyfigures outlier
Stack

Define all options needed for a stack. This is enabled only if there is more than one keyfigure defined in the Element section (CellContentKefiguresElement). A key figure for each stack needs to be prepared in advance in the Right-click menu. It is not possible to derive different stacks from a dimension field due to IBCS visalization rules. For visualizations of dimensions with more than ten entries use multiples (CellContentTypeMultiple).

Type

Determine if the stack should be shown absolute or in %. Stacks in % are calculated automatically according to the given sums.

Position

Position of an element within the category. To every position exists at least one frame position. A frame positions orientation depends on possible bars or waterfalls. Therefore a frame position can not be a bar or a waterfall itself.

Mid

This is the standard position. The elements position is in the middle of position left and right and has two frame positions, mid-left and mid right.

Left, top

The position before the middle element. In „time“ it is left, in „structure“ on top. The frame position is left-left or top-top.

Right, bottom

The position after the middle element. In „time“ it is right, in „structure“ on the bottom. The frame position is right-right or top-top.

Value Labels
Alignement

Determine if the values of a stack are drawn inside or outside of the bar.

Show small elements

Determine if small values should be drawn or not (default).

Units

Determine if units from data rules should be drawn.

Totals
Show

Determine if you want to show all values, none of them, smallest and largest value or selected values, according to a predefined logic.

Rule Editor

Open the rule editor to define a set of values to be displayed

Overlap others

Determine if the sums are allowed to overlap. If not, the rightmost value is removed.

100%-line

Determine if a 100% line is displayed.

Scaling helper
celltypes single keyfigures scalinghelper
Input

The page Input will only be relevant if the chart type Table is chosen. If there are comments, lists or flags added as keyfigures the Input section will be available.

Input2

In this area, it’s possible to manage where and how the inputs regarding comments, lists, or flags is being saved.

  • Input is saved with no extra key: Possibility to add an extra variable which will be included in the save key in the database.

  • 1 of 2 key columns: Depending on how many dimensions are used it’s possible that the input is just saved referring to one of them. Otherwise the 2nd key column has to be added as well. If you have the dimensions Region and Country the input will be saved either Region|Input or Region|Country|Input.

  • The Log checkbox will additionally create logging information for the added input.

  • The Release function allows to release comments. They will be flagged in the database after right click.

  • Save all allows the developer to define a variable which saves all the inputs included.

The listing in the main part of the input section shows the available keyfigures.

  • With Length, it’s possible to limit the length of the added comments to a specif number of characters.

  • The Source defines a common table (database) for the added input. It’s possible to choose between existing common tables, create new ones or define an own one ('Self').

  • The Save as is an individual add on for each input which will be added to the main key in the common table. With this options it’s possible to trigger each individual comment.

  • In the Key field, a specific save variable can defined. this options is relevant when the above mentioned Save all function is not allowed. This variable can consider the current selections while adding the comment which makes it possible to comment on the smallest level of detail.

  • With the Edit checkbox the editability of the input can be regulated. This is something which can also be done in the data properties.

  • The Mandatory checkbox makes an input necessary for the end-user if it’s activated.

  • Text copy settings are relevant when the application is being transported. Active means that the content/input will be transported whether the application is duplicated or published. The D activates the transport of the content just in case the App is duplicated

  • An activated Check function regulates if just numbers or dates can be added in the input keyfigure. This options only exists for comments.

In case you are using two dimensions and have activated the 2 of 2 key columns functions and are using an individual Save as name and a Key variable the saved input in the common table looks like this:

Dimension 1 | Dimension 2 | Save as | Key variable | Input content

7.2. Tables

The layout of tables can be configured using the table dialog.

7.2.1. Inside the table dialog

table adjust

The table dialog offers a list of all the columns defined as keyfigures and settings for Columns and Rows. In the Columns field, you can set three different behaviours for the table layout:

  • Adjust depending on content,

  • Use available space,

  • No automatic adjustment.

Adjust depending on content

The Adjust depending on content setting arranges the columns so they take the minimum width necessary to display the contents without ellipsing, but you can still set a minimum and a maximum width using the Min. width and the Max. width settings respective, but no inidividual widths can be set.

Use available space

The Use available space setting spans the entire table to the maximum width of its parent container. By using the Fix option, you can then set individual columns to occupy only their minimum necessary width to give more space to the remaining columns. You can still set a minimum and maximum width for the columns.

No automatic adjustment

The No automatic adjustment setting is the most flexible, as it lets you set individual widths, minimal widths and maximal widths for each column.

7.2.2. Per-column settings

The column list is where you can set individual settings to each column, depending on the column behavior you set for the table as well as changing the order of columns by draging-and-dropping the entries.

Column order

The column order can be set by dragging them with the drag icon. The No. will change accordingly.

Fix

The Fix checkbox is used to force the specified width to the respective column.

Widths

For each column you can set the width, minimum width and maximum width in either pixels (px), millimeters (mm), or percentage of the table width (%).

If you have chosen the mode Use available space, please note that trueChart tries to optimize so that all table contents are displayed. If trueChart cannot calculate the optimal width of a table column, it uses the value specified in the Notation Manual as a starting point for the calculation. You can override this by defining a minimum.
Hide

Use the Hide checkbox to hide a specific column.

Actual width

Act. width indicates the actual width the column will occupy.

7.2.3. Width units

You can set the width, maximum and minimal widths in four different units:

  • Pixels (px)

  • Millimeters (mm)

  • Percent (%)

  • Weighted (w)

The Split columns evenly button in the Columns fieldset defines a uniform width for all non-hidden columns. It doesn’t work in the Adjust depending on content mode. Width of value columns can be defined in the Notation manual and is overridden by a custom setting in the table dialog.

7.3. Multiple

celltypes multiple

Multiple is a chart type featuring multiple Single charts in one. Thus, settings for each chart are similar to those of the Single chart type.

The following sections cover the special handling of the Multiple chart type and those settings that only apply for it. For general chart settings, refer to the topics covered in the Single chart type section.

7.3.1. Multiple cases, borders

With Multiple cases, borders different settings for each generated cell of the multiple may be set. To add cases, click the '' sign on the right side of an existing case. To remove a case, click the '-' sign on the right side of the case which should be removed. Cases are identified by a given *Name*. This name is used to identify the cases in the *Subcases* tab. By default, a case is named 'Normal'. The cases are applied from top to bottom and the first valid case is applied to a cell. You may sort the cases by drag-and-drop the gray box in the beginning of the line, next to the '' sign. For every case, borders may be set for the Top, Right, Bottom and Left as well as the Title font For every case created, different settings for the borders (Top, Right, Bottom and Left) as well as the Title (Bold yes or no) may be set. In the example below, two cases have been created. The first case is only valid for a certain dimension value using Applies to. This case will draw a green border around the cells affected and writes the Title in bold. All other cases, as Applies to and Condition is 'true', will have a border as well according to the color set in the Notation Manual and the Title is not written in bold.

Multiple cases borders screen01

7.3.2. Subcases

Subcases manage the content for each cell of the Multiple. Case is the name of the case defined in the Multiple cases, borders tab. Grid cell inditifies the grid cell within the multiple by Row and Column. For each case, differente subcases may be added. To add cases, click the ‚+‘ sign on the right side of an existing case. To remove a case, click the ‚-‚ sign on the right side of the case which should be removed To switch positions of cases, click on the two circled arrows of the first case and then on the '<' sign of the second case. To activate a case, click on the gray box next to the '-' sign. The currently active case is indicated by a blue box. Important: All settings in the tab Categories and Keyfigures are applied only to the currently active case. The Condition is used to control under which circumstances the subcase is shown. Context defines which data contex is used for each individual subcase. This conext overwrites the context from the multille definition in tab Type. Alignment controls the starting point of Categories and Elements within the cell. Possible entries are Start, Mid and End. Axis Linking determines if the case should use axis linking or not. In the example below, there are two subcases namen Bold and Normal with two Rows and one Column each. The currently active cell is the second Row in the First Column of the case Bold indicated by the blue box next to the '-' sign.

Subcases screen01

7.4. Text

Type determines, if this cell should contain a Title, a Subtitle or a Comment.

Variable dependency defines a relation to a variable. Per value of the variable, a text can be defined.

If the content of the variable of the Show condition is „1“ (=true), the text is appear.

If the content of the variable of the Edit condition is „1“ (=true), the text may be edited by the user.

if the checkbox Log is active, all changes of text are logged in the trueChart database.

Default determines, if the default text should appear.

Check-Sign:

  • Active means the text content of the cell is transported to the target system and target comments are replaced.

  • Inactive means the target system text will stay.

  • Backend means that the transport activity determines if this kind of text is transported or not.

D-Sign:

  • Active means the text content of the cell is always transported to the target system and target comments are replaced.

  • Duplication means that the text is transported if the app was duplicated, but not if the app was published.

If Type is Comment, following configuration are possible:

  • Allow to add comment rows below of a comment

  • Allow to add comment columns on the left side of a comment

  • Allow to add linked numbers for comments

  • Allow to add comment columns on the right side of a comment

  • Allow to add comment rows above of a comment

Text Screen01

7.5. Button

The Button cell type lets you create simple buttons for basic control functions of trueChart.

To create a new button, choose Button from the list of available types in the cell dialog, choose a name (i.e. button label) and a function from the Function list to be executed when the button is clicked.

Multiple functions can be defined by adding new entries to the list using the plus icon.

celltypes button functions

Available functions are:

  • Toggle Show/Edit Mode*

  • Save comments*

  • Save object

  • Refresh

  • Export as PDF

  • Export as Image

  • Export as Vector Graphic

  • Export as Excel

  • Reload*

  • Reload common tables

As buttons can perform functions across multiple trueChart extensions on the same sheet, the Extension list is to set the extension for which the selected function takes effect. Those functions marked with * are applied globally.

7.6. Button+

Despite its merely evolutionary name, the Button+ type offers a number of new features and functionality.

To access its features, click the Edit button, on the right side of the window:

celltypes buttonplus

7.6.1. The Button Editor

The Button Editor is a powerful tool for setting both a button’s appearance and its behavior, i.e. the action triggered when the button is pressed. It will be opened when you click on State Settings in one of the button’s states.

Features

The settings are divided into five categories (General, Layout, Style, Color and Actions) covered in the following sections.

General

buttoneditor general

The General tab features five options:

Type

The Type list gives you a selection of various predefined button appearances, all of which can be fine-tuned in the adjacent tabs. Apart from that, you can choose between simple, image, and custom in the General section. The latter two of which can be used to create an image-based or custom-CSS-based button respectively.

State

The State list is a sub-list of the Type list and covers the normal, active and disabled state of the previously chosen type.

Icon

Using the Icon option you can define an additional icon for the button out of the Font Awesome or Qlik Sense icon repository.

Text

The Text field is the text used as the label on the button.

Tooltip

With the Tooltip option, you can define the text shown when the user hovers over the button.

Help other users to understand your button’s effect by describing it in the tooltip.

If you’ve chosen the image type you can additionally define an Image url, the Position, and Size of your background image in the Image section.

buttoneditor imagebg

To be able to display images with an image button, these images must first be saved (uploaded) to the trueChart Image Library and selected from there. All images of the trueChart Image Library are stored within the Sense app and are automatically available in duplicated and exported apps.

The trueChart Image Library could not changed in published apps since theese are read only in Sense. Existiing images still could be reused.

buttoneditor imagelibrary

The trueChart Image Library offers the possibility to import images from different sources, so you can upload one or more files directly or via a URL. To use images from the Qlik Sense media library, it is necessary to manually store the URL of the individual images as image URL in the button or to import them into the trueChart Image Library using the URL import function.

Other features available in the trueChart Image Library are: Rename, Replace / Update, Delete. The image download is not supported in ie11.

Since the contents of the image library are saved globally in an app, they can not be copied to an other app when copying an extension object. The recommended way to do this is: first export the necessary images in the source app and then import them again into the target mage library. Since the used image has the same names, these images then will be displayed correctly in the copied objects.

Custom css

If you’ve chosen the custom type you can define your own CSS rules on the button, giving you the maximal flexibility for the button’s appearance.

Layout

The Layout tab is for defining the metrics of the button. You can set…

Dimension

In the Dimension section, you can set the width and height of the button inside its boundaries. This is set to 100% by default but can be set to any value using CSS units or auto to make the button as large as its contents demands.

Position

In the Position section, you can set the horizontal and vertical alignment of the button inside its boundaries, which is only effective if the respective width or height is set to a value other than 100%.

Content alignment

In the Content alignment section, you can define the alignment of the button’s text and the icon. The Text alignment is only effective for multiple lines of text on the button.

Content position

In the Content position section, you can set the horizontal and vertical alignment of the content itself (i.e. the text and the icon together). This is only effective if the respective width or height of the button is not set to auto.

Padding

With the Padding setting, you can disable a predefined padding by choosing Off or override the default padding by choosing On which allows you to set the values in CSS padding syntax.

Margin

With the Margin setting, you can disable a predefined margin by choosing Off or override the default margin by choosing On which allows you to set the values in CSS margin syntax.

buttoneditor layout
Style

In the Style tab, you can set the visual appearance of the button’s content including:

Font settings

In the Font section, you can set the font properties, i.e. Family, Weight, Style, and Size.

Icon size

Icons have a fixed size, but you can change the scaling in the Icon section using the Size slider to choose between 1x, 1.5x, 2x, 3x, 4x or 5x.

Background repetition

If you defined a background on your button you can control how the background is repeated with the Repeat setting in the Background section.

Border

With the Border setting, you can disable a predefined border by choosing Off or override the default border by choosing On which allows you to set the border’s color, radius, width, and style. The radius is given in CSS border-radius syntax.

Shadow

The same applies for the button’s shadow in the Shadow section. By using On you can define a custom border according to the CSS box-shadow syntax: none|h-shadow v-shadow blur spread color |inset|initial|inherit.

buttoneditor style
Color

The Color tab is used to set the colors for the normal and hover state of the button. This overrides the colors you’ve set in the Colors section of the Appearance pane and those given by the button type in the General tab of the Button Editor. For a detailed list of accepted color expressions, refer to Appendix A.1.

buttoneditor color
Actions

In the Actions tab, you can define triggers, that is the actions to take effect when a certain event on the button is triggered. Possible events to attach actions are:

On click

Triggered when the user clicks the button.

Buttons without triggers and actions, for example, when used as text or image placeholders, do not apply hover effects. In order to achieve this behavior, all triggers must be removed via the delete icon.

Before navigation

Triggered when the sheet is closed or changed.

On load

Triggered when the element loads. This can be used to define initial actions like making selections.

To avoid critical actions being scattered all over other different items, On load actions like those for initial selections should be defined on a designated element (such as an otherwise non-functional button that serves to show the company’s logo).

On selection

Triggered when the button is selected.

Custom

Define your own event you can give a custom name. This can be used by involving HiCo.performCustomTrigger("triggername", "triggerdata") in a custom action. For every event, you can define one or multiple actions, such as Go to sheet to change the view to a different sheet or Select match to alter the current selection.

buttoneditor actions
Execution Order

Actions of a specific trigger are executed in the order they are defined (from top to bottom) without explicitly waiting for each other to be finished before executing the next one. In case of asynchronous calls this may lead to a different execution order. For most actions (like selecting fields, setting variables, etc.) this is the best option, because they will be performed as fast as possible. This leads to less requests to the "Qlik Sense Engine" and results in better performance/stability. For use cases were the execution order is important, every action can be defined as "sequential" where the execution order will then be respected, by executing them one by one.

Using Expressions

Apart from static values, every input box that features Qlik Sense’s fx icon also accepts Sense expressions.

7.6.2. Available actions for triggers

The following sections cover all the actions that can be defined for a trigger, including their parameters:

None
Action Parameters

None

No parameters.

Custom
Action Parameters

Custom

A custom JS function to be executed with the Custom event.

Navigation
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.

buttoneditor-actions-gotoapp

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. 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.

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.

  • 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. If omitted, it will be inserted at the end of the body. Target clipboard adds the generated link to the clipboard and shows a message to the user.

Limitations:
  • In "Qlik Sense Desktop" the Email target doesn’t work.

  • In mashup/story mode the URL can’t be properly generated.

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.

Select excluded

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.

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.

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 publicated apps, it is neccessary to create a corresponding Security Rule on the Qlik Sense server.
Other
Action Parameters

Toggle fullscreen

Expression which must result 0 (disable fullscreen), 1 (go to fullscreen) or can be empty (toggles current fullscreen mode). This action is only on click trigger avaliable, due to browser security restrictions.

7.7. URL

URL allows to embedd web page as content of the cell. The URL has to be enclosed by single quotes.

Height and Width specify that the content will be at least this big.If any of the dimensions is larger than the actual cell size then scrolling will be activated.

URL Screen02 1

As soon as a web page is embedded, the context menu of trueChart is available at the top of the cell.

URL Screen01

The URL cell does not work in the Qlik Sense Desktop Client.

8. Commenting

trueChart features different ways to create comments on sheets, covered in the following sections.

  • Inline comments

    • Object-specific comments (self)

    • Common comments (common table)

  • Perspective comments (with optional references)

  • Title

  • Subtitle

8.1. Editing comments

In Edit Text mode (changeable via right-click menu), every comment can be edited by clicking on it.

comment editor

The editor features various means of formatting the text, such as font settings, color, alignment, etc. In addition to regular text editing features, it offers the following:

  • Ok: Close the editor. The same can be achieved by clicking anywhere on the page outside the comment editor.

  • Variables: Insert a variable.

  • Brush: Copy formatting. To use, highlight a formatted text, click on the brush icon, and highlight the text to apply the formatting to. This only works inside the same comment, it cannot be applied to another one.

  • Tx: Remove all formatting of highlighted text.

8.2. Perspective comments

Perspective comments are comments that can be linked to specific data points on your chart. A new area for perspective comments in your extension can be created by adding a Text cell from the cell dialog and choosing Comment from the Type list.

celltypes text comment

The comment toolbar contains two additional buttons regarding comment linking:

comment toolbar references
  • Circled 1: Add a new reference. This creates two numbers. One will be attached to the comment itself while the other can be dragged freely on the page. References can be linked to trueChart visualizations by dragging the number on top of one.

  • Crossed out 1: Remove all references of this comment.

8.2.1. Editing perspective comments

When hovering over comment cells, plus and trash buckets icons appear. These icons allow you to remove and add new perspective comments.

comment cell hovering
  • Plus icon: Inserts a new comment line or column at the position where the icon is located.

  • Trash bucket icon: Deletes the current comment. If there are several comments in the comment line, they will all be removed.

9. Indications

Indications are visual elements employed on a chart to either show differences of the elements represented in a visualiation or enhance the meaning and importance of specific elements.

To get an overview of all the indications used in a trueChart extension and to edit, delete or copy them, open Overall, Indications from the right-click menu. This will open the Indications dialog showing the Compares and Highlights in the respective tabs.

indications compares 1

9.1. Compares

Comparisons are used to provide the message with information. To create this final view we use the trueChart right click menu.

Compare final
  1. Open the menue and click on Compare, Add
    01 Compare

  2. Then select the starting bar and then to the target bar
    02 Compare

  3. Your first compare is now there

Follow these steps to edit an existing compare:

  1. Open the right-click menu and select Compare, Edit
    03 Compare

  2. To make some further adjustments to the compare, we can now define the style of it
    04 Compare
    05 Compare
    06 Compare

  3. We can even add a description to it
    09 Compare

9.2. Highlights

Highlights are used to put emphasis on a visual element, such as a chart bar, its label, its category, etc.

9.2.1. Creating a new highlight

To create a new highlight, right-click on the element in your visualization you want to apply the new highlight to and choose Highlight, Add from the right-click menu.

highlights create 1

9.2.2. Editing highlights

Clicking on Highlight, Edit from the right-click menu will open the Highlights tab of the Indications dialog.

highlights edit

From the Type list, you can select between four different types of highlights: Category label, Compare, Legend, and Value. With the Keyfigure type you can choose if you want to highlight the element itself or its label. The Category setting is to identify the category by Text or by Position. You can then define either of these two in the Position input box. From the Keyfigure list, you can choose the keyfigure that contains the text or position to highlight.

9.2.3. Deleting highlights

Highlights are deleted by either clicking on a highlighted element and choose Highlight, Delete from the right-click menu or removing them in the Highlights tab of the Indications dialog.

10. Settings

10.1. Document settings

The Document Settings are relevant for the whole document and not for current user settings.

10.1.1. Overall

settings document overall 1
  • With the check box Allow user specific you can decide if My settings setups have priority over the overall document settings.

  • Choose between Design or Presentation Mode, the app will be displayed with design possibilities or as a published app for the end user.

  • Choose if unlicensed objects are shown.

  • Set up the preferred Date Format and the Update Timeout.

10.1.2. Numbers

settings document numbers

Here you can set up all relevant settings regarding numbers and the presentation style of numbers and units like the positions and the separators.

10.1.3. Scaling groups

settings document scalinggroups

Decide whether you want automatic or manual scaling for all the scaling groups used in this document. In the section scaling helper it’s possible to define further specifications regarding the scaling.

10.2. My settings

In My Settings it’s possible to set up general settings for the design and presentation within the application. Important: These settings are just relevant for the current user!

  • Choose between Design or Presentation Mode, the app will be displayed with design possibilities or as a published app for the end user.

  • Default: Choose the used language.

  • Date Format: Set up your preferred date format.

settings mysettings overall

In Numbers and Scaling groups you can decide which separators (decimals, thousands) will be used within the app and if the different scaling groups are calculated manually.

settings mysettings numbers
settings mysettings scalinggroups

11. Notation Manual

The Notation Manual is used for the central definition of all visualization settings with the aim of an identical representation of all trueChart visualizations on the respective system. The Notation Manual can only be edited by users with the "Notation Manual" permission.

The settings dialog can be opened via the trueChart context menu trueChart > Overall > Notation Manual.

All settings have a direct effect on all apps of the system after saving. Changes should therefore be made very carefully!
This area of the documentation is still under construction and therefore incomplete. If you have any questions regarding content, please contact support@highcoordination.de.

11.1. General

11.1.1. Text

Adaption for mobile devices

Adjusts, if active, the respective text sizes automatically depending on the current width of the browser window. Smaller text sizes also result in smaller representations of charts.

notation manual general text

11.2. Table

11.2.1. Others

Column
Column width

Defines the default column width of a table column for value columns and columns with visual representations.

Distance between columns

Defines the default space between two table columns.

Distance between columns big

Defines the space between columns if they are of different types (like comment, expression, value). It is also used to separate different annotators from each other.

notation manual table other

Appendix A: Release Notes

trueChart v2018.2.8

2018-09-13

Features and Improvements

  • Support for Qlik Sense June & September 2018 [HICO-41107]

  • Separate daily logging files for backend and ui logs

Bugfixes

  • Common Table Comments are handled wrong during publication [HICO-41787]

  • Exception after duplicating a sheet [HICO-41792]

Known Issues v2018.2.7

trueChart v2018.2.7

2018-08-15

Features and Improvements

  • Support for Qlik Sense June & September 2018 [HICO-41107]

Bugfixes

  • Add missing legend position migration for structure charts [HICO-41463]

Known Issues v2018.2.7

trueChart v2018.2.6

2018-08-03

Features and Improvements

  • Support for Qlik Sense June & September 2018 [HICO-41107]

Bugfixes

  • Sync stops with error, app not usable anymore [HICO-41238]

  • JS error 'Cannot read property 'extendedModel' of null' after the update to 2018.2.5 [HICO-41401]

  • Server error while synchronization when initializing an APP with two identical comment objects [HICO-41410]

  • JS error 'Cannot read property 'border' of null' after the update to 2018.2.5 [HICO-41466]

Known Issues v2018.2.6

trueChart v2018.2.5

2018-07-02

Features and Improvements

  • Support for Qlik Sense June & September 2018 [HICO-41107]

Bugfixes

  • Action "Toggle fullscreen" not disables in auto mode (no condition) [HICO-41183]

Known Issues v2018.2.5

trueChart v2018.2.4

2018-06-14

Important notice

With the update v2018.2.4, the HiCoConverter must be updated, as the internally used port has changed from 9090 to 30090.

Reason for this is the offline download functionality through the Qlik Sense Mobile App. This generally did not work if the HiCoConverter windows service was running.

The HiCoConverter always has used port 9090 (since the first release) but since September 2017 Sense now offers the DownloadPrepService, which also uses the same port.

To update the HiCoConverter follow these instructions: HiCoConverter update process.

Features and Improvements

  • New button action "Unlock Field" [HICO-40891]

Bugfixes

  • Comment column is missing in Excel Export [HICO-41027]

  • No session error message in Qlik Sense Mobile [HICO-41134]

  • Paste without formats not working in some cases [HICO-41135]

  • "Variable missing" dialog on snapshot export on some cases (printing) [HICO-41137]

  • Qlik Sense Mobile offline download not working, when HiCoConverter windows service is running (port 9090 is used) [HICO-41171]

Known Issues v2018.2.4

trueChart v2018.2.3

2018-05-31

Bugfixes

  • Common table comments not stored in desktop version (no service) [HICO-41077]

  • Error on sync after publish, cause of inconsistent comment data in app [HICO-41080]

Known Issues v2018.2.3

trueChart v2018.2.2

2018-05-25

Features and Improvements

  • Options to disable sense snapshot and maximize object buttons [HICO-2931]

  • Clickable links in readonly HTML-inline comments [HICO-40992]

Bugfixes

  • Table objects do not always draw if a caluclation condition was used for multiple data contexts and changed later [HICO-40822]

  • Button does not perform any further actions if a previous action was defined incorrectly and cannot be executed. [HICO-40885]

  • JS-Exception when try to scroll a (unnecessary) scrollable comment [HICO-40886]

  • Stories Export PDF/PPT failes in some cases [HICO-40897]

  • Button Action "Select Value(s)" not working for all field types (numeric vs. text) [HICO-40918]

  • Duplication of published apps looses trueChart Defintion (Workaround: Duplication of sheet afterwards) [HICO-40929]

  • SelectValues action in button do not select, when field already has selections [HICO-40944]

  • onSelection trigger of a button skips the first onSelection event [HICO-40967]

  • Empty button expressions cause trueChart to be drawn only the first time [HICO-41016]

  • trueChart does not draw after multiple incorrect synchronizations with the server [HICO-41046]

  • trueChart sometimes does not paint on apps published with versions before 2017.12.x [HICO-41050]

Known Issues v2018.2.2

trueChart v2018.2.1

2018-03-01

Features and Improvements

  • Support of clustered nodes with different URLs (internal, external) [HICO-40823]

Bugfixes

  • Tables column headings can no longer be hidden [HICO-40819]

  • Reload action (button+) does not save the loaded data [HICO-40825]

  • Inline comments are unnecessary or wrongly cropped at some resolutions or the height calculation is incorrect [HICO-40850]

Known Issues v2018.2.1

trueChart v2018.2.0

2018-03-01

Features and Improvements

  • Respsonsive & mobile behavior

    • Responsive chart and table text sizing [HICO-2569]

    • Menubar and buttons with variable font sizes, scaled depending width of browser window [HICO-2901]

  • Button+

    • New action "Go to app" (document chaining) [HICO-2564]

    • New action "Share app" (email | clipboard) [HICO-40703]

  • Commenting

    • Delete comment row & column buttons in comment object [HICO-2741]

  • General

    • Changed default-setting for keyfigure description (structure to top-mid & time to left-mid) [HICO-40551]

    • Support for Java 9 [HICO-40546]

Bugfixes

  • Interruption in aggregated header lines after every second column [HICO-2937]

  • Grid rows too high due to cell line wrap [HICO-32019]

  • Unexpected behaviour of table mover dialog [HICO-40489]

  • Invalid session not correct displayed to end user [HICO-40553]

  • Column width is wrong calculated for bar charts in table [HICO-40600]

  • Adding a comment reference and reloading the page breaks trueChart [HICO-40605]

  • Sense context menu can go out the viewport when tcMenu is present [HICO-40626]

  • Empty dimension leads to an error [HICO-40683]

  • Automatic title height is not calculated correctly in sense desktop [HICO-40729]

  • When calculating the scaling, incorrectly hidden columns are taken into account [HICO-40737]

Known Issues v2018.2.0

Export / Printing Support
Qlik Sense

The standard export of trueChart by Qlik Sense is fully supported.

Mail&Deploy

trueChart fully supports image and text export, especially for comments, with external partner solution Mail&Deploy. For more information on the Mail&Deploy export solution, click here: http://www.mail-and-deploy.com.

nPrinting

nPrinting is supported from version June 2018 and with trueChart from v2018.2.5.

Qlik Sense Mobile
  • Offline mode is generally not supported by trueChart at the moment!

  • No connection error with trueChart within Qlik Sense Mobile (online mode) [HICO-41257]

    • PROBLEM: If trueChart was installed without defining qlik sense host name (possible as of v2018.2.1), trueChart cannot be used with the Qlik Sense Mobile App (online mode), because a communication error always occurs. This error only occurs when used with Qlik Sense Mobile (all versions). In "normal" browsers, even mobile, there are no problems.

    • ERROR: The cause of the error is the Qlik Sense API (Global API) which returns 127.0.0.1 / localhost instead of the correct server hostname. Thus trueChart cannot communicate with that.

    • SOLUTION: We have already opened a support case at Qlik Sense: 01442491 - Global API: qlik.getGlobal().session.options.host returns wrong host name within qlik sense mobile (online)

    • WORKAROUND: Using the fixed configuration of the sense host URL when installing trueChart: CrossDomain installation

General
Bugs
  • IE11: Weighted grid columns differs in IE11 in combination with (content based optimization) (HICO-40492)

MashUp Support

Currently only one app with trueChart extensions can be used in a MashUp. Different apps with trueChart extensions result in runtime errors in Sense. (HICO-2014)

Comments

Comment reference disappears when linking to categories with '#' in the text (HICO-1864)

DB: Oracle no longer supported

Since the Oracle DB is no longer supported from trueChart version 3.2, we offer support for migration to a other supported DB like MS SQL or MySQL. Please contact us at support@highcoordination.de.

trueChart v2017.12.4

2018-02-12

Bugfixes

  • Visibility of "Save input" entry in context menu is inverted [HICO-40735]

Known Issues v2017.12.4

trueChart v2017.12.3

2018-02-08

Bugfixes

  • JS-Exception while loading inline comments with desktop version [HICO-40717]

  • Time of reference creation takes too long (>1-10sec) [HICO-40720]

  • JS-Exception while loading tables [HICO-40725]

  • No Repaint after invalid Hypercube [HICO-40730]

Known Issues v2017.12.3

trueChart v2017.12.2

2018-02-06

Bugfixes

  • Comment columns to small in table export (Mail & Deploy) [HICO-40721]

Known Issues v2017.12.2

trueChart v2017.12.1

2018-01-31

Features and Improvements

  • Visual columns in Table Exporter should consider their minimum [HICO-40642]

Bugfixes

  • Excel Export works not correct (columns empty) [HICO-40708]

  • Exception while loading table [HICO-40710]

  • Exception when moving comment references that was linked to a multiple [HICO-40714]

  • Inline icon in button text is not displayed [HICO-40712]

Known Issues v2017.12.1

trueChart v2017.12.0

2017-12-21

Epic

  • Full support of Sense export function for trueChart (HICO-1496)

Features and Improvements

Commenting

  • Configurable deactivation of text formatting during copy & paste (HICO-2710)

  • Better click- and touchable inline comment flags (HICO-2732)

  • Show user name instead of technical account name in comment tooltip (HICO-2738)

  • New and remove number button for text editor (HICO-2739)

  • New Delete comment button for text editor (HICO-2740)

  • Configuration of text color & color inversion for comment references in notation manual (HICO-2824)

Visualisations

  • Optional display of totals, subtotal and rest as values in time, structure & multiple charts (HICO-1901)

  • Button+: Automatic line breaks in button+ text (HICO-2324)

  • Button+: Mark actions for sequential or parallel execution (Execute in order) (HICO-40445)

  • Table: Optimize automatic width calculation for tables in responsive grid layout (HICO-2913)

Mobile support

  • Dragging comment references on touch devices (HICO-2945)

  • Support devices with both touch & mouse input capabilities (HICO-40442)

Performance

  • General performance improvements (HICO-2949)

  • Performance: Reduced intial loading time (due to reduced count of extension assets) (HICO-40464)

Export - Mail&Deploy-support

  • Use defined column width of value representations for visual representations (HICO-40468)

  • Place width information in additional header row with the height 0px (HICO-40525)

General

  • Integration of trueChart Context Menu in Sense Context Menu (HICO-1922)

  • Option to enter title, subtitle or footnote (HICO-2889)

  • Keep scrolling position after edit comment and selection (HICO-40460)

Bugfixes

  • Commenting: Common table comments are overwritten when importing to another server (HICO-40578)

  • Commenting: Error on updating an perspective comment (HICO-2915)

  • Commenting: Comment grids returns wrong preferred size (height) (HICO-40494)

  • Commenting: Cannot edit inline comments of more than one extension with same layout structure (HICO-40579)

  • Table: Inline / Table comments are not saved if external contexts are used (HICO-2102)

  • Table: Table row lines not shown in case of waterfall chart column (HICO-26250)

  • Table: Freeze when categories for tables are disabled (HICO-11247)

  • Table: Empty comment columns reserve more space then needed (HICO-40465)

  • Multiple: Exception with multiples after change keyfigure data rule to total type (HICO-2840)

  • Button+: Custom actions are not visible initially after reopening button+ editor (HICO-40454)

  • Mobile support : Layout not correct in iOS / Safari (HICO-2932)

  • Layout: Placeholder padding differs in Firefox, EDGE, IE11 (HICO-2826)

  • Layout: Editor controls moved if root container larger than 100% (HICO-2884)

  • Layout: Grid editor controls popover doesn’t show on proper side (HICO-2894)

  • Layout: Inserted Rows/Cols reference original definition instead of copy (HICO-2898)

  • Layout: Pasting of comment cells do not work when pasting twice (HICO-2923)

  • Layout: Exception for value linked structure charts without data (HICO-28668)

  • Layout: Changing a weighted column also changes subgrids column settings unintentionally (HICO-40486)

  • Data Context: Exception due to error in data context definition (HICO-2941)

  • Notation Manual: Exception while save notation manual & local version could not be used (HICO-11346)

  • Export: trueChart excel export only export one comment column (HICO-40455)

  • trueChart Service: Special characters with the copy function lead to a broken display of the app list in backend (HICO-2695)

  • Installer: last version number registered instead of new (HICO-2887)

  • Qlik Sense: Exception TypeError: Cannot set property 'isHandled' of undefined (HICO-2942)

  • Qlik Sense: Display in snapshot play modus brocken with Qlik Sense September 2017 (HICO-40452)

Known Issues v2017.12.0

Bugs
  • IE11: Weighted grid columns differs in IE11 in combination with (content based optimization) (HICO-40492)

  • QLIK-84768: Qlik Sense Field API OnData event doesn’t fire on fields. This is a Bug in Sense November 2017. So if this issue hamper your work (some customers used this for custom navigation), we recommend you to use Qlik Sense September 2017.

Qlik Sense Support

trueChart works with Qlik Sense 3.0 and later. The standard export of trueChart by Qlik Sense is fully supported.

nPrinting Support Export

nPrinting is not yet supported. After the necessary. technical clarifications with nPrinting this will work after next release in beginning of 2018.

Export solution support: Mail&Deploy

trueChart fully supports image and text export, especially for comments, with external partner solution Mail&Deploy.

MashUp Support

Currently only one app with trueChart extensions can be used in a MashUp. Different apps with trueChart extensions result in runtime errors in Sense. (HICO-2014)

Comments

Comment reference disappears when linking to categories with '#' in the text (HICO-1864)

DB: Oracle no longer supported

Since the Oracle DB is no longer supported from trueChart version 3.2, we offer support for migration to a other supported DB like MS SQL or MySQL. Please contact us in case of need.

trueChart v2017.9.3

2017-11-02

Features and Improvements

  • Revise surface optimization to avoid incorrect scaling and empty surfaces [HICO-2908]

Bugfixes

  • Tiny text in inline comments is cut of [HICO-2875]

  • Warning in browser-log: "Unsupported Media Type - woff2" after enable edit mode [HICO-2946]

  • Display of unnecessary scrollbars in tables despite "content-based optimization" [HICO-3481]

  • Pasted inline comments are truncated in height [HICO-20524]

Known Issues v2017.9.3

trueChart v2017.9.2

2017-10-30

Features and Improvements

  • Border formatting of table text exports [HICO-2886]

  • Speed improvement by caching the variables to be evaluated [HICO-2948]

  • General performance improvements [HICO-2949]

Bugfixes

  • Button+ in trueChart does not update when changing variables from outside [HICO-2879]

  • Table vertical alignment not working [HICO-2927]

  • Performance issue for working comment editor in IE11 [HICO-2952]

Known Issues v2017.9.2

trueChart v2017.9.1

2017-10-19

Features and Improvements

  • Border formatting of table text exports [HICO-2886]

  • Performance improvements due to complex grid layouts and usage of larger tables for annotation in conjunction with the copy option [HICO-2893]

  • Re-enable empty option in CellDialog [HICO-2922]

Bugfixes

  • Broken support of copy/cut & paste of grid containers and empty cells [HICO-2854]

  • Sub-Grids which are content-based do not lead to smaller rows in parent grids [HICO-2885]

  • Error during painting while dimension is empty and only keyfigures are defined [HICO-2892]

  • Performance issue with changes in layout editor [HICO-2903]

  • Cell Padding leads to differend cell widths [HICO-2906]

  • Layout collapsed for weighted rows in Sense Desktop [HICO-2907]

  • Weighted width for comment columns not working as expected [HICO-2912]

  • Comment texts in tables are not wrapped, but truncated [HICO-2917]

  • Border+padding are not respected correctly for subgrids [HICO-2924]

Known Issues v2017.9.1

trueChart v2017.9.0

2017-09-28

Epic

  • Responsive mobile support for Qlik Sense [HICO-1472]

  • Responsive tables - Improving the definitions of widths for tables and table columns [HICO-1491]

  • trueChart User Documentation -→ Available from October 2017 on www.highcoordination.com [HICO-2513]

  • Integration of reporting solutions such as CIA Report Manager and Mail & Deploy [HICO-2570]

  • Support of Sense 2017.09 Release [HICO-2572]

Features and Improvements

  • Unnecessary scrollbars (1px) for time and structure charts [HICO-1815]

  • Auto save for inline comments [HICO-1912]

  • Button+: Definition of padding & margin [HICO-2301]

  • Button+: Image library (apps include used images for export) [HICO-2506]

  • Remove blue grid selector frame [HICO-2555]

  • Support tooltips on mobile devices [HICO-2556]

  • Responsive Grid-Editor [HICO-2568]

  • Improvements in usage during mobile commenting [HICO-2573]

  • Button+: Add new toggle fullscreen action [HICO-2687]

  • Synchronized table setting for automatically legend-linked tables in same grid [HICO-2714]

  • Button+: Custom CSS can defined as expression [HICO-2718]

  • Table-column width option "weighted" [HICO-2728]

  • Support of table export (Mail & Deploy) [HICO-2729]

  • Support of perspective comments export (Mail & Deploy) [HICO-2730]

  • HiCo.API: Code-Notification after trueChart painting [HICO-2736]

  • Optional automatic chart linking based on actual grid layout [HICO-2745]

  • Help & About dialog with reference to trueChart user documentation on www.highcoordination.com [HICO-2792]

  • Layout migration to responsive grid layout [HICO-2819]

  • Export comment references as Unicode Circled Numbers [HICO-2823]

  • Support of MSSQL multiple instances [HICO-2862]

  • Using shift+enter in comment editor breaks fix row height behavior [HICO-2878]

Bugfixes

  • Comment tables without dimension get unnecessary edge + scrollbars [HICO-1950]

  • Fix jumping column with while changing edit-mode for inlinecomments [HICO-2684]

  • Recreate SessionObject with used ID fails after update to sense june 2017 [HICO-2694]

  • Button+ does not respect cell padding and border definitions [HICO-2737]

  • Paint fails when using needle, symbol (& line) with position left-left, right-right in time or bottom-bottom in structure charts [HICO-2758]

  • Selection not working for other positions then mid [HICO-2760]

  • No input save changes in context menu for comment objects with 'Auto Save' = false [HICO-2773]

  • Indented bullet- and numbered lists not displayed correct in inline comments [HICO-2777]

  • trueChart definitions were lost during publishing, if it was created with an older trueChart-version than v2017.7.0 [HICO-2830]

  • Cell menu crashes in QlikView for new trueChart objects [HICO-2833]

  • Inline copy function was broken in v2017.7.0 [HICO-2836]

  • JSON-Error during transport [HICO-2863]

Known Issues v2017.9.0

Bugs
  • Broken support of copy/cut & paste of grid containers [HICO-2854]

  • Layout Editor Controls moved if root container larger than 100% [HICO-2884]

  • Sub-Grids which are content-based do not lead to smaller rows in parent grids [HICO-2885]

Qlik Sense Support

trueChart4Sense works only with Qlik Sense 3.1 and later.

Export / Print

The standard export of trueChart by Qlik Sense or nPrinting is not yet supported. After the necessary technical clarifications with Qlik will work after this release with Top Prio on the implementation.

We expect this to be resolved by November 2017!

Support for external export solutions trueChart is working to support export solution Mail&Deploy (mid september 2017).

  • Code-Notification after trueChart Painting: 4 different solutions to determine if painting has finished [HICO-2736]

    • 1. paint-Promise: The Paint-Function returns a promise that is resolved as soon as all extensions are painted. So if the print-Function waits for that promise the printing functionality could run after that.

    • 2. Promise in HiCo.API: By calling the trueChart api, there is a function under "HiCo.API" called painterPromise. That will return an promise which is resolved after the painting has fulfilled. Code-Example:

      HiCo.API.paintingPromise().then(
        function (e ) { console.log( "HiCo.API.paintingPromise here after paint..." ) });
    • 3. document.body event: A "tcPainted"-Event is emitted on document.body when painting has finished. But, this event is triggered too when a repaint happens and after that all extensions have finished painting. Code-Example:

      document.body.addEventListener( "tcPainted", function (e ) {
        console.log( "tcPainted event");
        console.log( e );
      } );
    • 4. Watching console: Watch console output for an occurrence of "finish painting trueChart". trueChart writes to the console a "finish painting trueChart" after trueChart is painted.

      MashUp Support
  • Currently only one app with trueChart extensions can be used in a MashUp. Different apps with trueChart extensions result in runtime errors in Sense. [HICO-2014]

    Comments
  • Comment reference disappears when linking to categories with '#' in the text [HICO-1864]

  • Inline / Table comments are not saved if external contexts are used [HICO-2102]

    Button+
  • onNavigationBefore trigger not working in IE [HICO-2435]

    DB: Oracle no longer supported

    Since the Oracle DB is no longer supported from trueChart version 3.2, we offer support for migration to a other supported DB like MS SQL or MySQL. Please contact us in case of need.

trueChart v2017.7.2

2017-08-28

Bugfixes

  • Comment References of a duplicated app are lost when republishing [HICO-2699]

  • Localization in actions tab of button+ Editor is not always correct [HICO-2723]

  • pasting from ms office was broken in release v2017.7.0

  • sorting of button actions was broken in release v2017.7.0

Known Issues v2017.7.2

trueChart v2017.7.1

2017-08-01

Bugfixes

  • Missing user permissions after "go to source" function from initially loaded storymode [HICO-2672]

  • trueChart doesn’t paint in story mode (play) of a published app [HICO-2677]

  • The legend won’t be shown in a time chart if all values are 0 [HICO-2679]

  • Value-Linked time charts cutted an not fully visible [HICO-2680]

Known Issues v2017.7.1

trueChart v2017.7.0

2017-07-27

Epic

  • Support for story mode and snapshots [HICO-1713]

  • Support for master items [HICO-1726]

  • Support of Qlik Sense June 2017 [HICO-1788]

Features and Improvements

  • Update comment editor (CKEditor) incl. new skin [HICO-1784]

  • Definition of Factor, Decimals and Unit in data context can be defined with variables [HICO-1817]

  • Store trueChart-Version in DB [HICO-1837]

  • Correct positioning of comment references across sheets, mash-ups, story and mobile views [HICO-1989]

  • Changed trueChart select behavior in Sense to match the default behavior [HICO-2212]

  • Enable grid row/column insertation from table cell [HICO-2270]

  • Prevent intial notional manual warning dialog, show status message instead [HICO-2336]

  • Performance Improvement: Deferred variable evaluation in trueChart [HICO-2387]

  • Remove "Save" notification after changes for dimensions and formulas [HICO-2399]

  • Simplify and optimize text processing for dublication and (re-)publication [HICO-2485]

  • Enforced file (JS, CSS…​) update after version change [HICO-2536]

  • Consideration of changed table column order for Excel export [HICO-2551]

  • Option to reload sub pages in HiCo mashup to support multiple trueChart apps [HICO-2579]

  • Reactivation of application copy function in trueChart service for sense [HICO-2631]

  • Revise labels in trueChart Installer [HICO-2644]

Bugfixes

  • Comment numbers are moved to the upper left when dragging and dropping [HICO-1638]

  • Log option can not be activated for subtitles [HICO-1818]

  • Selection on 2nd value does not work in table with two dimensions [HICO-1894]

  • Broken "Reset" functionality in Notation Manual dialog [HICO-1981]

  • Context menu on comment references does not work if a menu is already open [HICO-2107]

  • No datetime’s are saved in embedded (H2) database [HICO-2199]

  • Double-click on title line leads to incorrect position of the comment tooltip [HICO-2283]

  • Data Context names for copying data rules are not equal to the context name in the Data Context dialog [HICO-2395]

  • "Show Objects" option does not work in QS, highlighting remains invisible [HICO-2423]

  • Column is not exported if the used decimal is a defined as expression [HICO-2478]

  • Application search does not find existing Applications & Sorting wrong [HICO-2491]

  • Linking of comment references on table categories with two or more dimensions not possible [HICO-2511]

  • Inline comments disappears after closing cell menu [HICO-2512]

  • FileName in hicoobject to long (sense desktop) [HICO-2542]

  • "Preview" inversion for pasted comments is bad to read [HICO-2607]

  • "Keyfigure to value" setting in Notation Manual is not reflected correctly in click behavior auto value [HICO-2609]

  • Session licenses do not work correctly with anonymous users after manually assigning rights [HICO-2637]

  • Navigation in cell-dialog partially broken [HICO-2642]

  • Exceptions when cutting/pasting cells with comments [HICO-2648]

  • Scaling for time chart failes [HICO-2650]

  • Switch chart type from table to structure/timechart throws errors and prevents painting [HICO-2664]

  • Installer sets up SSL after checkbox is changed from enabled to disabled [HICO-2667}

  • JS-Exception: Uncaught (in promise) TypeError: Cannot read property 'hasLabel' of undefined [HICO-2673]

Known Issues v2017.7.0

Support dropped for all saved states created with version 1.8.6 or earlier (prior to version 1.9.0). To ensure full functionality of objects with those old states, they must be opened in any trueChart version from 1.9.0 to 3.1.8 and then saved.

Qlik Sense Support

trueChart4Sense v3.2.x and higher works only with Qlik Sense 3.1 and later.

MashUp Support

Currently only one app with trueChart extensions can be used in a MashUp. Different apps with trueChart extensions result in runtime errors in Sense. [HICO-2014]

DB: Oracle no longer supported

Since the Oracle DB is no longer supported from trueChart version 3.2, we offer support for migration to a other supported DB like MS SQL or MySQL. Please contact us in case of need.

Comments
  • Comment reference disappears when linking to categories with '#' in the text [HICO-1864]

  • Inline / Table comments are not saved if external contexts are used [HICO-2102]

Export / Print

Qlik Sense 3.x and june 2017 does not support exporting complex extensions like trueChart to PDF correctly. Exporting via the sense story mode to PDF or PowerPoint (pptx) is also not supported, due to the same reason. As a workaround, it is recommended to use the trueChart export functions in the context menu. (Applies to Qlik Sense versions v2.x and v3.x)

  • Column is not exported if the used factor is a defined as expression [HICO-2478]

Button+
  • onNavigationBefore trigger not working in IE [HICO-2435]