Skip to main content Skip to complementary content

Combo Chart - AJAX/Webview

The combo chart allows you to combine the features of the bar chart with those of the line chart: you can show the values of one expression as bars while displaying those of a second expression as lines or symbols.

Combo Chart: Object Menu

The object menu can be opened as a context menu by right-clicking on a sheet object, or by clicking the Menu icon in the object caption (if shown).

The commands in the menu may vary depending on whether WebView is used from inside QlikView or opening the document in a web browser. The menu contains the following commands:

Menu commands
Command Details
Properties...

Opens the Properties dialog for the active sheet object.

Notes

Allows creating and sharing notes about the current object.

Detach The chart title is appended with the text “(Detached)” and the chart is no longer updated with selections made in the document (though selections may actually still be made from the chart). The command is available only if the chart is attached. By making a copy of a chart and detaching it, you may make direct comparisons between the copy and the original.
Attach Attaches a detached chart. The chart becomes dynamically linked to the data. The command is available only if the chart is detached.
Set Reference This option sets a chart reference, such as a fixed plot of the chart with the current selections. When further selections are made in the document the reference plot remains, dimmed in the background. Chart axes will be adjusted to always include the maximum of the background data set and the current data set. The current data set is always plotted on top of the reference plot. Some portions of the reference plot may be obscured by the current data set plot. The display of reference chart plots is only possible in some chart types, such as bar charts, line charts, combo charts, radar charts, scatter charts, grid charts and gauge charts with needles. It is not possible to set a reference for a chart that contains a drill-down or a cyclic group. The reference will be lost when closing the document or when reloading data. The maximum number of objects that can be included when using the Set Reference option is 500.
Clear Reference This command is replaced with the Set Reference command when a reference is set. By choosing it the previously set reference will be cleared and the chart will revert to normal plot mode.
Clear All Selections

Clears all the current selections in the active sheet object. Clicking on the Eraser icon in the object caption (if shown) produces the same result.

Copy

Copies the selected sheet object(s) to the clipboard. This function only copies sheet objects, not data or images.

Print...

Opens the selected sheet object(s) in tabular format in another browser window. Clicking on the Printer icon in the object caption (if shown) produces the same result.

Send to Excel

Exports possible (including selected) values to Microsoft Excel, which is automatically launched if not already running. The exported values will appear as one column in a new Excel worksheet. For this functionality to work Microsoft Excel 2007 or later must be installed on the computer. Clicking on the Spreadsheet icon in the object caption (if shown) produces the same result.

Export...

Opens the Save as dialog where path, file name and (table) file type for the exported data content can be specified.

Fast Change

Makes it possible to change the current chart into another chart type. Clicking on the Fast forward icon in the object caption (if shown) produces the same result. Only available if Fast Type Change in Chart has been enabled on the Caption tab of the Properties dialog.

Minimize

Iconizes the object. Clicking on the Minimize icon in the object caption (if shown) produces the same result. This command is available only if minimizing is allowed in the object's Properties dialog on the Caption page.

Restore

Restores a minimized or maximized object to its previous size and location. Double-clicking the icon of a minimized object or clicking the Restore icon in the object caption (if shown) of a maximized object produces the same result. This command is available only for minimized or maximized objects.

Maximize

Enlarges the object to fill the sheet. Clicking on the Maximize icon in the object caption (if shown) produces the same result. This command is available only if maximizing is allowed in the object's Properties dialog on the Caption page.

Remove

Removes the selected object from the sheet.

Combo Chart Properties

The Properties dialog is opened by selecting Properties from the Object menu. If the Properties command is dimmed, you probably do not have the privileges necessary to perform property changes.

Dimensions

Choose dimensions in the drop-down list. To add a dimension, click Add. Select a dimension in the drop-down. Use the Move icon to move items in the list. The Remove icon removes items from the list. For more settings, click the More... button.

Dimension

  • Enable Conditional: Marking this check box hides or shows the dimension dynamically, depending on the value of a condition expression entered, by clicking the Function button in the edit box below.
  • Dimension: Displays the currently selected dimension.
  • Show Label: Mark this check box to show a dimension label (the field name) on the x-axis.
  • Suppress Null Values: If this check box is marked, the field selected as Dimension above will not be displayed in the chart if its value is NULL.
  • Show All Values: Mark this check box to show all the dimension field values in the chart, including logically excluded values.
  • Show Axis Labels: Mark this check box to show legend (names of field values) on the x-axis for the selected dimension field.
  • Limit Axis Label Characters: Mark this check box to limit the length of the dimension value strings to be shown on axes and in the chart legend. Specify the number of characters in the input field, or drag the slider to the desired value. Truncated values will be followed by ... in the chart. This option can be used independently to the other options in this group.
  • Trellis Setting First Dimension: Marking this check box will enable the trellis chart, where an array of charts that are based on the chart's first dimension are displayed.
  • Fixed Number of Columns: Enter the number of columns you want the trellis chart to display. Specify the number of columns in the input field, or drag the slider to the desired value.
  • Fixed Number of Rows: Enter the number of rows you want the trellis chart to display. Specify the number of rows in the input field, or drag the slider to the desired value.
  • Second Dimension: Enables the second dimension in the trellis chart. If a secondary dimension is used, the first dimension values will be displayed as columns in the trellis matrix, whereas the secondary dimension values will be displayed as rows in the trellis matrix.

Sort

Sets the sort order of the values in the sheet object. Some sort options may not be available for all sheet objects.
If more than one sort order is specified, the sort order will be state, expression, frequency, numeric, text, load order. State refers to the logical state (selected, optional, or excluded).

  • Primary Sort: Y-Value: Sets whether the dimension values should be sorted according to the numeric value of the y-axis. This option is not available for calculated dimensions. Frequency: Sorts the field values by frequency (number of concurrences in the table).Numeric Value: Sorts the field values by their numeric values.Text: Sorts the field values in alphabetical order.Load Order: Sorts the field values by the initial load order.
  • Secondary Sort: Frequency: Sorts the field values by frequency (number of concurrences in the table).
    Numeric Value: Sorts the field values by their numeric values.
    Text: Sorts the field values in alphabetical order.
    Load Order: Sorts the field values by the initial load order.
  • Sort by Expression: Sorts the field values according to the expression entered. The value may be entered as a calculated formula. Click Function to open the Edit Expression dialog.
  • Keep Selected on Top: Enable this to keep the selected values on top.

Limits

  • Restrict which values are displayed using the first expression: These properties are used to determine how many dimension values are displayed in the chart, according to settings made below.
  • Show only: Select this option if you want to show the First, Largest or Smallest x number of values. If this option is set to 5, there will be five values displayed. If the dimension has Show Others enabled, the Others segment will take up one of the five display slots. The First option will return the rows based on the options selected on the Sort tab of the property dialog. If the chart is a Straight Table, the rows will be returned based on the primary sort at the time. In other words, a user can change the values display by double-clicking on any column header and making that column the primary sort.The Largest option returns the rows in descending order based on the first expression in the chart. When used in a Straight Table, the dimension values shown will remain consistent while interactively sorting the expressions. The dimensions values will (may) change when the order of the expressions is changed.The Smallest option returns the rows in ascending order based on the first expression in the chart. When used in a Straight Table, the dimension values shown will remain consistent while interactively sorting the expressions. The dimensions values will (may) change when the order of the expressions is changed.Enter the number of values to display. The value may be entered as a calculated formula. Click Function to open the Edit Expression dialog. Select Include Boundary Values to include the dimension value that contains the comparison value.
  • Show only values that are: Select this option to display all dimensions values that meet the specified condition for this option. Select to display values based on a percentage of the total, or on an exact amount. The relative to the total option enables a relative mode which is similar to the Relative option on the Expressions tab of the property dialog. The value may be entered as a calculated formula. Click Function to open the Edit Expression dialog.
  • Show only values that accumulate to: When this option is selected, all rows up to the current row are accumulated, and the result is compared to the value set in the option. The relative to the total option enables a relative mode which is similar to the Relative option on the Expressions tab of the property dialog, and compares the accumulated values (based on first, largest or smallest values) to the overall total. The value may be entered as a calculated formula. Click Function to open the Edit Expression dialog.
  • Show Others: Enabling this option will produce an Others segment in the chart. All dimension values that do not meet the comparison criteria for the display restrictions will be grouped into the Others segment. If there are dimensions after the selected dimension, Collapse Inner Dimensions will control whether individual values for the subsequent / inner dimensions display on the chart. In the Label field, enter the name you wish to display in the chart. If no text is entered, the label will be automatically set to the expression text.
    The value may be entered as a calculated formula. Click Function to open the Edit Expression dialog. If there are dimensions after the selected dimension, Collapse Inner Dimensions will control whether individual values for the subsequent / inner dimensions display on the chart.
  • Show Total: The chart will display a total for the selected dimension when this option is enabled. This total behaves differently than the expression total, which is still configured on the Expressions tab of the property dialog. Label: Enter the name you wish to display in the chart. If no text is entered, the label will be automatically set to the expression text. The value may be entered as a calculated formula. Click Function to open the Edit Expression dialog.
  • Use Global Grouping Mode: The option only applies to inner dimensions. When this option is enabled the restrictions will be calculated on the selected dimension only. All previous dimensions will be ignored. If this is disabled, the restrictions are calculated based on all preceding dimensions.

Axis

  • Show Axis: Check this box to show the axis.
  • Axis Width: Enter the width of the axis and its tick marks, or drag the slider to the desired value.
  • Major Label: Select Horizontal, Vertical or Tilted display of the major labels.
  • Minor Label: Select Horizontal, Vertical or Tilted display of the minor labels.
  • Show Grid: Check this box to show a grid in the chart originating from the tick marks of the x-axis. The grid lines can be formatted using the Grid Style and Grid Color settings.
  • Show Minor Grid: Check this box to show minor lines in-between the grid lines. Only available if Show Grid is selected. The grid lines can be formatted using the Grid Style and Grid Color settings.
  • Stagger Labels: Select this option to stagger x-axis labels when they become to many to show side by side.
  • Reverse Stagger: X-axis labels are normally staggered bottom-up from left to right. When marking this check box, the stagger will be reversed to top-down.
  • Continuous X: Sets the x-axis to be continuous, i.e. it will be interpreted numerically and shown with numerically correct intervals.
  • Force 0: Fixes the lower edge of the chart to zero on the y-axis. This option is not available when a logarithmic axis is used.
  • Static Min: Sets a fixed minimum value for the axis. The value may be entered as a calculated formula. Click Function to open the Edit Expression dialog.
  • Static Max: Sets a fixed maximum value for the axis. The value may be entered as a calculated formula. Click Function to open the Edit Expression dialog.
  • Static Step: Sets a fixed interval for tick marks on the axis. If this setting results in more than 100 tick marks, the value used will be modified. The value may be entered as a calculated formula. Click Function to open the Edit Expression dialog.
  • Backcast: By entering an integer in the edit field, you force the x-axis to be extended to the left of the actual data points plotted. This is useful when using trend lines. The backcast line will be dotted. The value may be entered as a calculated formula. Click Function to open the Edit Expression dialog.
  • Forecast: By entering an integer in the edit field, you force the x-axis to be extended to the right of the actual data points plotted. This is useful when using trendlines. The forecast line will be dotted. The value may be entered as a calculated formula. Click Function to open the Edit Expression dialog.

Expressions

Choose expressions in the drop-down list. To add an expression, click Add. Select an expression from the drop-down. Use the Move icon to move items in the list. The Remove icon removes items from the list. For more information click the More... button.

Expression

  • Enable: Marking this check box will enable the selected expression. If the box is not marked, the expression will not be used at all.
  • Conditional: Marking this check box hides or shows the expression dynamically, depending on the value of a condition expression entered, by clicking the Function button in the edit box below.
  • Label: The label of the expression. Enter the name you wish to display in the chart. If no text is entered, the label will be automatically set to the expression text. The value may be entered as a calculated formula. Click Function to open the Edit Expression dialog.
  • Expression: Displays the currently selected expression.
  • Comment: Enter a comment to describe the purpose and function of the expression. The value may be entered as a calculated formula. Click Function to open the Edit Expression dialog.
  • Invisible: Hides the expression.
  • Show in Percent (Relative): The chart shows the result in percent instead of absolute numbers.
  • Accumulate Expression:

    Check this box to accumulate expressions. Click Engine to open the popup.

    • Accumulation Popup: Select one of the options to decide whether the values in the sheet object should be accumulated or not.
      • Accumulate: In an accumulated chart, each y-value is added to the y-value of the following x-value.
      • No Accumulation: The y-values of the selected chart expression will not be accumulated.
      • Full Accumulation: Each y-value accumulating all previous y-values of the expression. Full accumulation does not work if the chart trellis is enabled.
      • Accumulation Steps: Enter a number in the box or drag the slider to set the number of y-values in the expression to be accumulated.
  • Use Trendlines:

    Check this box to use trendlines. Click Engine to open the popup.

    Trendline Popup: Choose one of the following Trendline options:

    • Average: The average is plotted as a straight line.
    • Linear: A linear regression line is plotted.
    • Polynomial of 2nd degree: A polynomial trend line of the second degree is plotted.
    • Polynomial of 3rd degree: A polynomial trend line of the third degree is plotted.
    • Polynomial of 4th degree: A polynomial trend line of the fourth degree is plotted.
    • Exponential: An exponential trend line is plotted.

      For each option, it is possible to check the Show Equation box and the Show R2 box.

      • Show Equation: If this check box is marked for a specific expression, the expression's trend lines will be complemented by the trend line equation expressed as text in the chart.
      • Show R2: If this check box is marked for a specific expression, the expression's trend lines will be complemented by the coefficient of determination expressed as text in the chart.





  • Show in Legend: When several expressions are used, this option displays a legend showing the expressions and their corresponding colors next to the chart.
  • Statistical Distribution:

    Check this box to use statistical distribution. Click Engine to open the popup.

    • Statistical Distributions Popup: Enable the checkboxes Error Above, Error Below, and Error Symmetric to utilize one or two expressions following the selected expression as auxiliary expressions for bars plotted on top on the main expression's data points.
      • If Error Symmetric is selected, then only one auxiliary expression will be used and plotted symmetrically around the data point.
      • If Error Above or Error Below is selected, then two auxiliary expressions will be used and plotted above and below the data point respectively.
      • The error bar expressions should return positive numbers.
      • The auxiliary expressions utilized for error bars are preceded by the icons (error symmetric), (error above) or (error below) in the Expressions list and cannot be utilized for anything else in the chart.
      • If there are no expressions already defined after the selected expression, new dummy auxiliary expressions will be created automatically.
  • Bar, Line, Symbol Settings:

    Check this box to make layout settings for bars, lines and symbols. Click Engine to open the popup.
  • Value Display Settings:

    • Show Values on Datapoints: Mark this check box to display the result of the expression as text on top of the data points.
    • Text as Popup: Mark this check box to have the result of the expression shown in the popup balloon messages appearing when hovering over a data point in a chart in the layout. This option can be used with or without any of the other display options. It is thus possible to have an expression that does not appear in the chart itself, but only in hover popups.
    • Text on Axis: Plots the result of the expression at each x-axis value, the axis and the axis labels.
  • Attribute Expression Styles:

    • Background Color: Define an attribute expression for calculating the basic plot color of the data point. The expression used should return a valid color representation (a number representing the Red, Green and Blue components as defined in Visual Basic) which is typically achieved by using one of the special chart color functions. If the result of the expression is not a valid color representation, black will be used.
    • Bar Offset: Define an attribute expression for calculating the bar offset.
    • Line Style: Define an attribute expression for calculating the line style.
    • Show Value: Define an attribute expression for calculation whether the data point plot should be complemented with a “number on data point value“, even if Values on Data Points has not been selected for the main expression. If Values on Data Points is selected for the main expression the attribute expression will be disregarded.
  • Number Format Tab: Each field has a default number format which can be set in the Document Properties: Number page. It is however possible to use a separate number format for an individual sheet object. This property page applies to the active object and contains the following controls for formatting values:

    • Number Format: Choose a number format from the alternatives below.
    • Default: Both numbers and text. Numbers are shown in original format.
    • Number: Shows numeric values with the number of digits set in the Precision field.
    • Integer: Shows numeric values as integers.
    • Fixed to: Shows numeric values as decimal values with the number of decimal digits set in the Decimals field.
    • Money: Shows values in the format set in the Format Pattern field. The default format is the Windows Currency setting.
    • Date: Shows values that can be interpreted as dates in the format set in the Format Pattern field.
    • Time: Shows values that can be interpreted as time in the format set in the Format Pattern field.
    • Timestamp: Shows values that can be interpreted as date + time in the format set in the Format Pattern field.
    • Interval: Shows time as sequential time increments (e.g. format = mm shows the value as the number of minutes since calendar start (1899:12:30:24:00).
    • Format Pattern: The format code that further specifies the display format of the field. ISO sets the format to the ISO standard. Only valid for Date, Time, Timestamp and Interval. Sys sets the format to the system settings.
    • Precision: The number of digits that will be displayed.
    • Decimals: Sets the number of decimals included.
    • Decimals Separator: Sets the symbol for decimal separators.
    • Thousand Separator: Sets the symbol for thousand separators.
    • In Percent: Shows formatting in percentage instead of absolute numbers. The setting is only available for Number, Integer and Fixed to.
    • Preview: Shows a preview of the number format specified above.

Axis

  • Show Axis: Check this box to show the axis.
  • Axis Width: Enter the width of the axis and its tick marks, or drag the slider to the desired value.
  • Split Axis: Check this box to split the y-axis into two parts, thus creating an impression of two charts sharing a common x-axis.
  • Position: Choose Left or Right position.
  • Show Grid: Check this box to show a grid in the chart originating from the tick marks of the x-axis. The grid lines can be formatted using the Grid Style and Grid Color settings.
  • Show Minor Grid: Check this box to show minor lines in-between the grid lines. Only available if Show Grid is selected. The grid lines can be formatted using the Grid Style and Grid Color settings.
  • Log Scale: If this box is checked, the scale will be logarithmic.
  • Force 0: Fixes the lower edge of the chart to zero on the y-axis. This option is not available when a logarithmic axis is used.
  • Static Min: Sets a fixed minimum value for the axis. The value may be entered as a calculated formula. Click Function to open the Edit Expression dialog.
  • Static Max: Sets a fixed maximum value for the axis. The value may be entered as a calculated formula. Click Function to open the Edit Expression dialog.
  • Static Step: Sets a fixed interval for tick marks on the axis. If this setting results in more than 100 tick marks, the value used will be modified. The value may be entered as a calculated formula. Click Function to open the Edit Expression dialog.
  • Static Center: Sets a fixed value on the axis which will be positioned in the center of the plot area. The value may be entered as a calculated formula. Click Function to open the Edit Expression dialog.

Show Title

By default, the label of the first expression defined is set as chart title. Clear the check box if you do not wish to have a chart title. The title may be defined as a calculated formula for dynamic update. Click Function to open the Edit Expression dialog.

More.../Less...

Click this button to expand/collapse the foldout that contains additional tabs. Depending on if the Dimensions or Expressions field is active, different tabs are displayed.

Combo Chart Properties: Presentation

Some options may not be available for all objects.

Look

Click Settings to open the popup.

  • Top Angle: Defines the vertical angle of the 3D view. The value must be an integer between 0 and 30.
  • Side Angle: Defines the side angle of the 3D view. The value must be an integer between 0 and 45.

Orientation

Sets the orientation of the chart.

Color Style

Defines the color style on all plot colors in the chart. Click Settings to open the popup.

  • Persistent Colors: Locks the colors assigned to each data point even if selections reduce the total number of data points. In this mode color representation will never change for a given data point, but there is a risk of having two adjacent bars or slices with the same color for different data points.
  • Repeat Last Color: Select this check box to assign the last (18th) color to field values loaded as number 18 and forward. If this check box is left unselected, the 19th value (according to the original load order) will get the first color, the 20th value the second color, etc.

Show Legend

Displays the legend in the chart. Click Settings to open the popup.

  • Legend Style: Sets the legend style.
  • Vertical: Sets the vertical alignment of the legend.
  • Line Spacing: Specifies the distance between items in the legend.
  • Reverse Order: To reverse the sort order of the legend mark this check box.
  • Wrap Cell Text: If this check box is marked, the text of the legend items will be wrapped in two or more lines.

Stacked Bars

Checking this option displays the bars stacked instead of grouped.

Bar Distance

Enter a number or drag the slider to set the distance between the bars in the cluster.

Cluster Distance

Enter a number or drag the slider to set the distance between clusters in the chart.

Background

Sets the background of the chart. The following options are available:

  • Color: Click Caption color to select a color.
  • Image: Click Add image to change the image.
  • Dynamic Image: Enter a calculated expression to show dynamic background images that change with the selection.

Plot Area Background

Sets the background of the plot area. The following options are available:

  • Color: The plot area will have a colored background. Click Caption color to select a color.
  • Image: The plot area will have an image background. Click Add image to change the image.
  • Dynamic Image: Enter a calculated expression to show dynamic background images that change with the selection.

Plot Area Style

This control can be used to change the appearance of the plot area background. The following options are available:

  • Frame: A frame is drawn around the plot area.
  • Shadow: This options gives a shadow effect on the plot area background.
  • Minimal: The plot area background is removed.

Background Transparency

Enter a value in the box or drag the slider to set transparency for the chart.

More.../Less...

Click this button to expand/collapse the foldout that contains additional tabs.

General

  • Reverse Direction: When this check box is marked, the values shown in the chart will be reversed, i.e. if the 10 highest values are shown and the box is checked the chart will then show the 10 lowest values.
  • Max Values Shown: In this box, specify an upper limit for how many data points to show values for in the chart. If no limit is specified, values will be shown for all data points, which may affect the readability of the chart.
  • Suppress Zero-Values: If this check box is marked, all combinations of the dimension fields returning zero or null from all expressions will be disregarded in the calculation. This option is selected by default.
  • Zero on Bars: This setting is only applicable when Suppress Zero-Values is deselected. If the check box is marked and Values on Data Points is selected, zero values will appear as text above the data points. In other cases zero values will be suppressed.
  • Suppress Missing: If this check box is marked, all combinations of the dimension fields associated with only null values in all fields in all expressions will be disregarded in the calculation. This option is selected by default. Turning it off can be useful only in special cases, e.g. if null values is to be counted in a chart.
  • Synchronize Zero for Expression Axes: Synchronizes the zero level of the two y-axes (left/right or top/bottom).
  • Use Full Symbol Set: This alternative makes more symbol representations available (rings, triangles, etc.)
  • Allow Thin Bars: For charts with a non-continuous x-axis, QlikView will only display as many data points as can be accommodated in the plot area available. Remaining data points are truncated from the chart. By default bars will be drawn with a minimum width of four pixels, so that they are clearly distinguishable. Mark this check box to allow bar width down to one pixel.
  • Show All Bars: For charts with a non-continuous x-axis, QlikView will only display as many data points as can be accommodated in the plot area available. Remaining data points are truncated from the chart. Mark this check box to force plotting of all bars. The bars will be compressed and some data points may become obscured by others.
  • Vertical Numbers: Shows the values vertically.
  • Plot Numbers on Segments: Marking this check box will plot values on data points inside the segments instead of on top of them.
  • Popup Labels: By selecting this check box the values of the dimensions and expressions will appear as a pop-up balloon when hovering with the cursor over data point in the chart.
  • Highlight: If this check box is marked hovering with the mouse over a line or symbol in it will result in the line or symbol being highlighted for better overview. The highlighting applies also in the legend where applicable.

Chart Scrolling

Click Settings to open the popup.

  • Chart Scrolling Popup: Enable this check box to show a scroll control in place of the X-axis, when the number of bars exceeds the defined number. The scroll bar can be used to scroll the selection of the X-axis values that are displayed.
  • Calculation Conditions: The expression entered here sets a condition to be fulfilled for the chart to be calculated. If the condition is not fulfilled, the text 'Calculation condition unfulfilled' will be displayed in the chart. The value may be entered as a calculated formula. Click Function to open the Edit Expression dialog.

Styles

  • Legend: To set the color of the legend click Caption color. To set the font color of the legend click Font color. To set the font type click Font.
  • Chart Title Style: To set the font color of the chart title click Font color. To set the font type click Font.
  • Caption Font: To set the caption font type click Font.
  • Active Caption: To set the background color for the active caption click Caption color. To set the text color click Font color.
  • Inactive Caption: To set the background color for the inactive caption click Caption color. To set the text color click Font color.
  • Use Border: Mark this check box in order to use a border around the sheet object. Click the Caption color to set the color of the border.
  • Border Width: Specify a value or drag the slider to set the width of the border. The width is specified in pixels.
  • Rounded Corners: Click Settings to open the Rounded Corners popup.

    Information note

    Rounded Corners is only available if you have selected Advanced Styling Mode in Document Properties: General.

    • Rounded Corners Popup: Select Fixed or Relative roundness of the corners, and which corners to be affected. Also select Squareness by entering a value.
  • Scroll Bar Background: To set the scroll bar background color click Caption color.
  • Scroll Bar Slider: To set the scroll bar slider color click Caption color.
  • Scroll Bar Width: Specify a value or drag the slider to set the width of the scroll bar. This control affects both the width and the relative size of the scroll bar symbols.
  • Trendline Width: Specify the width of the trendline.
  • Error Bar: To set the error bar slider color click Caption color.
  • Error Bar Width: Specify the width of the error bar.
  • Error Bar Thickness: Specify the thickness of the error bar.
  • Reference Lines:
    • Reference Lines: Add a reference line by clicking Add.
    • Show Label in Chart: Displays the label next to the reference line.
    • Label: In the text box you can enter a title to be shown in the caption of the sheet object. If no Label is set, the name of the field will be used if Show Caption is selected. The value may be entered as a calculated formula. Click Function to open the Edit Expression dialog.
    • X-Axis: Select this option if the reference line should originate from the x-axis.
    • Expression: The value at which the reference line should be drawn. Enter an expression you wish to use as start point.
    • Line Weight: Specifies the weight of the reference line.
    • Line Style: Specifies the style of the reference line.
    • Line Color: Specifies the color of the reference line.
    • Use Show Condition: The reference line will be shown or hidden depending on a conditional expression which will be evaluated each time the chart is to be drawn. The reference line will only be hidden when the expression returns FALSE.
    • Condition: Enter the conditional expression. The value may be entered as a calculated formula. Click Function to open the Edit Expression dialog.
  • Text:
    • Text in Chart: Click Add to add text in the chart.
    • Text: The text added in Text in Chart are displayed here.
    • Tilt Angle: Specify an angle between 0 and 360 degrees for the text. The default is 0.
    • Horizontal Align: Sets the horizontal alignment.
    • On Top: The text currently selected in the list will be forced to the foreground when drawing the chart.
    • Text Style:
      • To set the background color for the text click Caption color.
      • To set the font color click Font color. To set the font type click Font.
    • Size Position: Sets the position and size of the text on the object.

Combo Chart Properties: Caption

Caption

  • Label: In the text box you can enter a title to be shown in the caption of the sheet object. If no Label is set, the name of the field will be used if Show Caption is selected.

  • The value may be entered as a calculated formula.

    Click Function to open the Edit Expression dialog.

  • Show Caption: When this option has been checked a caption will be drawn at the top of the sheet object. List boxes and other "box objects" will have the option switched on by default whereas buttons, text objects and line/arrow objects will not.

  • Caption Alignment: Can be Left, Centered, or Right.

  • Multi Line Caption (Word Wrap): If this option is checked, the text will be displayed in two or more rows.

  • Number of Rows: If multiple lines are allowed for the caption, specify the number of rows in the input field, or drag the slider to the desired number.

  • Caption Alignment: Can be Top, Centered, or Bottom.

More.../Less...

Icons in Caption

  • Menu: Opens the object menu.
  • Clear: Clears all the current selections in the active sheet object.
  • Print:  Opens the selected sheet object(s) in tabular format in another browser window. Some clients may not handle this setting!
  • Copy Data: Copies the field values in the sheet object. Some clients may not handle this setting!
  • Copy Image to Clipboard: Copies the sheet object as an image to the Clipboard. Some clients may not handle this setting!
  • Send to Excel: Exports possible (including selected) values to Microsoft Excel, which is automatically launched if not already running. The exported values will appear as one column in a new Excel worksheet. For this functionality to work Microsoft Excel 2007 or later must be installed on the computer. Some clients may not handle this setting!
  • Allow Minimize: When this option has been checked a minimize icon will be displayed in the window caption of the sheet object, providing that it is possible to minimize the object. Furthermore, this will make it possible to minimize the object by double-clicking the caption.
  • Auto Minimize: This option becomes available when Allow Minimize is checked. When Auto Minimize is checked for several sheet objects on the same sheet, all but one will be automatically minimized at any time. This is useful e.g. for alternately displaying several graphs in the same sheet area.
  • Allow Minimize: When this option has been checked a maximize icon will be displayed in the window caption of the sheet object, providing that it is possible to maximize the object. Furthermore, this will make it possible to maximizing the object by double-clicking the caption. If both Allow Minimize and Allow Maximize are checked, double-clicking will effect minimizing of the object.
  • Help Text: Here you may enter a help text to be displayed in a pop-up window. This option is not available at document level. The value may be entered as a calculated formula. Click Function to open the Edit Expression dialog.
    It is possible to enter e.g. a description of the sheet object. A help icon will be added to the window caption of the object. When the mouse pointer is over the icon, the text will be displayed in a pop-up window.
  • Fast Type Change: Here you can enable toggling between chart types. Not available for all objects. Click Settings to open the popup.
  • Fast Type Settings Popup: Check the boxes for the chart types you want to toggle between using fast type change.

Combo Chart Properties: Options

Options

Some options may not be available for all objects.

  • Read Only: Makes the chart read only, that is selections cannot be made by clicking or painting with the mouse in the chart.
  • Allow Move/Size: If this option has been deselected it will be impossible to move or resize the sheet object.
  • Allow Copy/Clone: If this option has been deselected it will be impossible to make a copy of the sheet object. This setting may not be handled by all clients.
  • Size Object to Data: Normally the borders around all table sheet objects in QlikView will shrink when selections cause the size of the table to be less than allocated size for the sheet object. By deselecting this check box this automatic adjustment of size will be turned off leaving any surplus space blank.
  • Allow Show Info in Caption: When the Info function is in use an info icon will be displayed in the window caption whenever a field value has information associated to it. If you don't want the info icon to be displayed in the caption, you can uncheck this option. Only available for list box, statistics box, multi box and input box.
  • Preserve Scroll Position: When marking this check box and the corresponding one in the User Preferences, Objects dialog, QlikView will preserve the vertical scroll position when a selection in table objects has been made.
  • Use Show Condition: The sheet object will be shown or hidden depending on a conditional expression which will be evaluated continuously depending on e.g. selections etc. The sheet object will only be hidden when the condition returns false. The value may be entered as a calculated formula. Click Function to open the Edit Expression dialog.
  • Normal: Specify the position of the object by setting Left and Top margins, and Width and Height of the object.
  • Minimized: Specify the position of the minimized sheet object by setting Left and Top margins, and Width and Height of the minimized object.
  • More.../Less...: The following options are available:
    • Owner: Domain and User Id of the owner.
    • Share Object: Enable to share objects with other users. Enabling this selection will enable the settings below.
    • Share with: Choose either Share with everyone or Share by username.
    • Users (Domain\UserID): If Share by username is chosen a list with added users will be shown.

      To add users click Add, a row is added, highlight the row to unlock it and edit the user information. To remove users click Remove after each user to be removed.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com