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:

Properties...

Opens the Properties dialog for the active sheet object.

Notes

Allows creating and sharing notes about the current object.

See: Notes and Comments

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

 

Pie Chart Properties: Presentation

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

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

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.

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 to set the background color for the active caption click . To set the text color click .

Inactive Caption

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

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

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... Click this button to expand/collapse the foldout that contains additional tabs.

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