Statistics Box - AJAX/Webview

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.

Field Select the field you want to show statistics for in the drop-down.
Displayed Functions In the list below, check the box to use the function. Enter an alternative label in the field to the right.
Numeric Count
Sample size, i.e. the number of numeric values among the possible values.
Null Count
Number of empty field values among the possible values.
Text Count
Number of alphanumeric values among the possible values.
Total Count
Total number of possible values. This is the same number as the frequency that can be shown in a list box.
Missing Count
Number of non-numeric values among the possible values.
Sum
Sample sum.
Average
Sample arithmetic mean.
Standard Deviation
Sample standard deviation.
Skewness
Sample skewness.
Kurtosis
Sample kurtosis.
Min
Sample minimum.
Max
Sample maximum.
Only Value
Only possible numeric value.

Statistics Box Properties: Presentation

Presentation

Show Standard Error Displays the standard error of the average and the standard deviation.
Cell Borders Displays borders between the cells in the sheet object.
Background Color Sets the background to a color, either a solid color or a gradient. Click to choose the color.
Background Image

Sets an image as background. Click to browse for an image. Click to open the Image popup.

More.../Less...

Style

Text To set the font type click .
Caption Font

To set the caption 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 to set the color of the border.
Border Width Specify the width of the border in the input field, or drag the slider to the desired width. The width is specified in pixels.
Rounded Corners Click to open the Rounded Corners popup.
Scroll Bar Width Specify the width of the border in the input field, or drag the slider to the desired width. The width is specified in pixels. This control affects both the width and the relative size of the scroll bar symbols.

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

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.

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