Statistics boxes can show most types of statistical entities such as sum, average, minimum etc. of the possible values of a field. The calculations are made dynamically, i.e. the display changes instantaneously as selections are made in sheet objects.
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:
Opens the Properties dialog for the active sheet object.
Allows creating and sharing notes about the current object.
See: Notes and Comments
All non-excluded values in the sheet object are selected.
All excluded values in the sheet object are selected.
All values in the sheet object are selected.
Clears all the current selections in the active sheet object. Clicking on the icon in the object caption (if shown) produces the same result.
|Clear Other Fields||
Clears the selections in all the other sheet objects, while maintaining the ones in the currently active sheet object.
Locks the selected value(s) in the active sheet object. (Unavailable if no selections have been made).
Unlocks the locked value(s) in the active sheet object. (Appears instead of Lock if selections have been locked).
Copies the selected sheet object(s) to the clipboard. This function only copies sheet objects, not data or images.
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.
Opens the Save as dialog where path, file name and (table) file type for the exported data content can be specified.
Removes the selected object from the sheet.
Statistics Box 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.