Statistics Box

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.

Statistics Box: 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

Select Possible

All non-excluded values in the sheet object are selected.

Select Excluded

All excluded values in the sheet object are selected.

Select All

All values in the sheet object are selected.

Clear

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.

Lock

Locks the selected value(s) in the active sheet object. (Unavailable if no selections have been made).

Unlock

Unlocks the locked value(s) in the active sheet object. (Appears instead of Lock if selections have been locked).

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.

Delete

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.

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?