Block Chart - AJAX/Webview

The Block chart shows the relation between expression values as blocks of varying area. From a display standpoint it is related to the pie chart. The chart may be shown with either segment height/width or segment area proportional to data. It is also possible to draw the chart with equal segment heights/widths, disregarding data points.

Block Chart: Object Menu

The object menu can be opened as a context menu by right-clicking on a sheet object, or by clicking the 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:

Properties...

Opens the Properties dialog for the active sheet object.

Notes

Allows creating and sharing notes about the current object.

See: Notes and Comments

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 By choosing this option you set a chart reference, i.e. 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 etc 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, i.e. 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, e.g. 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 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 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 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 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 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 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 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.

Block 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 . Select a dimension in the drop-down. Use the icon to move items in the list. The 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 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.

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.

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

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

Expressions

Choose expressions in the drop-down list. To add an expression, click . Select an expression from the drop-down. Use the icon to move items in the list. The 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 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 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 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.

Show in Legend

When several expressions are used, this option displays a legend showing the expressions and their corresponding colors next to the chart.

Value Display Settings

Check this box to define how to display values. Click to open the popup.

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.

Text Color
Define an attribute expression for calculating the text color of text associated with 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.

 

 

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

Block Chart Properties: Presentation

Presentation

Look Select one of the available looks in the drop-down.
Color Style Defines the color style on all plot colors in the chart. Click to open the popup.

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

Visible Levels A block chart can display a maximum of three levels of blocks, equivalent to the three dimensions allowed. By selecting 1, 2 or 3 you set the number of levels actually displayed.
Intermediate Level Captions Select this check box to have captions drawn on the intermediate dimension level in three-dimensional block charts.
Show Dimension Labels Check this alternative to include labels in the chart.
Background Sets the background of the plot area. Possible options are:
Color
The plot area will have a colored background. Click to select a color.
Image
The plot area will have an image background. Click to change the image.
Dynamic Image
Enter a calculated expression to show dynamic background images that change with the selection.
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

Popup Labels

By selecting this check box the values of the dimension(s) and expression(s) will appear as a pop-up balloon when hovering with the cursor over data point in the chart.

1st Dimension Relative Total

With this option, the percentage of the indicated 1st dimension value relative to the total is included in the pop-up.

2nd Dimension Relative Total

The percentage of the indicated 2nd dimension value as defined within the indicated 1st dimension value relative to the total.

3rd Dimension Relative Total

As above, but for the 3rd dimension level.

Value Relative First Dimension

The percentage of the indicated block relative to the total of the indicated 1st dimension value.

Value Relative Second Dimension

The percentage of the indicated block relative to the total of the indicated 2nd dimension value.

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 to open the Edit Expression dialog.

Styles

Dimension Labels

To set the font color click . To set the font type click .

Block Caption

To set the background color for the block caption click .
To set the font color click . To set the font type click .

Chart Title Style

To set the font color click . To set the font type click .

Caption Font

To set the caption font type click .

Active Caption

To set the background color for the active caption click . To set the font color click .

Inactive Caption

To set the background color for the inactive caption click .
To set the font color click .

Use Border

Mark this check box in order to use a border around the sheet object. Click the to set the color of the border.

Border Width

Specify the width of the border in the input field. The width is specified in pixels.

Rounded Corners

Click to open the Rounded Corners popup.

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. 

Text

Text in Chart

Click 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 .
To set the font color click . To set the font type click .

Size Position

Sets the position and size of the text on the object.

Block 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 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 Left/Centered/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 Top/Centered/Bottom
More.../Less...

Icons in Caption

Some options may not be available for all objects.

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 Maximize

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 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 to open the popup.

Fast Type Settings Popup

Check the boxes for the chart types you want to toggle between using fast type change.

Block 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 visible when the condition returns true. The value may be entered as a calculated formula. Click 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...

Options

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 , a row is added, highlight the row to unlock it and edit the user information. To remove users click after each user to be removed.

 

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?