Pie Chart - AJAX/Webview
Pie charts normally show the relation between a single dimension and a single expression, but can sometimes have two dimensions.
Pie 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:
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 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. |
Pie 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.
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 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 , 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.
Pie Chart Properties: Presentation
This section describes Pie Chart properties in Presentation.
Look
Select one of the available looks in the drop-down.Show Legend
Displays the legend in the chart. Click to open the popup.
Legend Settings 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.
Background
Sets the background of the chart. The following options are available:
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. Click to set the transparency.
More.../Less...
This section describes several properties in More.../Less...
General
- 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.
- 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.
- 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: This option is not supported for AJAX/Webview.
- 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
- Legend: To set the color of the legend click . To set the font color click . To set the font type click .
- Caption Font: To set the caption font type click .
- Chart Title Style:To set the font color of the chart title click . To set the font type click .
- Active Caption: To set the background color for the active caption click . To set the text color click .
- Inactive Caption: To set the background color for the inactive caption click . To set the text 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 a value or drag the slider to set the width of the border. The width is specified in pixels.
Rounded Corners: Click to open the Rounded Corners popup.
Information noteRounded Corners is only available if you have selected Advanced Styling Mode in Document Properties: General.
- Select Fixed or Relative roundness of the corners, and which corners to be affected. Also select Squareness by entering a value.
Text
This section describes properties in 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.
Pie Chart Properties: 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: 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.
Icons in Caption Properties
This section describes the More.../Less... in Icons in Caption property.
Menu
Opens the object menu
Clear
Clears all the current selections in the active sheet object.
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 97 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 in Caption
Check this box to use Fast Type Change in Caption.
- Fast Type Settings Popup: Check the boxes for the chart types you want to toggle between using fast type change.
Pie 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 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 , 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.