Multi Box - AJAX/Webview
The multi box is a sheet object that shows several fields simultaneously.
For each field in the multi box, you will also find a selection indicator: a small beacon that will give you information on the content of the multi box. A green selection indicator shows that there are selected values, a white that there are optional values, and a gray that there are no possible values in the drop-down list.
Multi 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. |
Clear All Selections |
Clears all the current selections in the active sheet object. Clicking on the |
Lock All Selections |
Locks the selected value(s) in the active sheet object. (Unavailable if no selections have been made). |
Unlock All Selections |
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. |
Copy cell value to clipboard |
Copies the selected cell value to the clipboard. |
Delete |
Removes the selected object from the sheet. |
Multi 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 | To add an item click ![]() ![]() ![]() For more information click the More... button. FieldSelect a field in the drop-down. LabelEnter the label name. The value may be entered as a calculated formula. Click RepresentationText Image Settings Popup Image Stretch No Stretch
Search ModeHere you may determine the default search mode, Wildcard, Fuzzy, Normal and Associative, to be used in any text search. Note: Associative is available as a search mode for list boxes only. Include Excluded Values in SearchThe drop-down list lets you choose between Yes, No or <use default> which applies the default setting as specified under User Preferences, General. Dropdown Select SettingsClick Dropdown Select Settings PopupIgnore NullNULL-values are not considered for the sake of displaying possible values of a specific field. Hide Excluded Toggles whether the excluded values of the field should be shown or not. Excluded values become unselectable as well. Show Frequency Toggles the status for whether the frequency of a field value is shown or not. By frequency is meant the number of selectable combinations in which the value occurs. This option is not available for calculated fields. In Percent Toggles the status for whether the frequency should be shown in absolute numbers or as percentages of the total number of entries. Override Locked Field Checking this option enables selections to be made in the sheet object even if it is locked. The sheet object will still be locked for selections made elsewhere in the document. Read Only Checking this option will prevent making selections in the sheet object. However, it will still reflect selections made elsewhere in the document. Dropdown Select Alignment Click Dropdown Select Alignment PopupNumber AlignHere you set the alignment of numeric field values in the list box. Text Align Here you set the alignment of text field values in the list box. Rows and Columns Click Rows and Columns PopupSingle ColumnWith this option checked, the list box field values will always be presented in a single column. Show Horizontal Scrollbar Check this box to display the horizontal scroll bar. Multiple Columns With this option checked, the list box field values will be presented in a two or more columns. Multiline Cells If this option is checked, the text will be displayed in two or more rows. Specify the number of rows to display in the input box, or drag the slider to the desired number. Order by Column In sheet objects with more than one column, values are displayed row-wise in the sort order specified. The Order by Column option switches to column-wise display. Cell Border The field values will be separated by horizontal lines, resembling the rows of a table. Cell Borderis automatically activated when the Wrap Textoption is checked, but may be consequentiality deactivated. SortSets the sort order of the values in the sheet object. Some sort options may not be available for all sheet objects.If more than one sort order is specified, the sort order will be state, expression, frequency, numeric, text, load order. State refers to the logical state (selected, optional, or excluded). Primary SortY-Value Secondary SortFrequency Sort by ExpressionSorts the field values according to the expression entered. The value may be entered as a calculated formula. Click Keep Selected on Top Enable this to keep the selected values on top. Number FormatEach field has a default number format which can be set in the Document Properties: Number page. It is however possible to use a separate number format for an individual sheet object. This property page applies to the active object and contains the following controls for formatting values: Override Default SettingsSelect to override the default settings for the active object.Number FormatChoose a number format from the alternatives below. Mixed Both numbers and text. Numbers are shown in original format. Number Shows numeric values with the number of digits set in the Precisionfield. Integer Shows numeric values as integers. Fixed to Shows numeric values as decimal values with the number of decimal digits set in the Decimalsfield. Money Shows values in the format set in the Format Patternfield. The default format is the Windows Currency setting. Date Shows values that can be interpreted as dates in the format set in the Format Patternfield. Time Shows values that can be interpreted as time in the format set in the Format Patternfield. Timestamp Shows values that can be interpreted as date + time in the format set in the Format Patternfield. Interval Shows time as sequential time increments (e.g. format = mm shows the value as the number of minutes since calendar start (1899:12:30:24:00).Format PatternThe format code that further specifies the display format of the field. ISOsets the format to the ISO standard. Only valid for Date, Time, Timestampand Interval. Syssets the format to the system settings. PrecisionThe number of digits that will be displayed. DecimalsSets the number of decimals included. Decimals SeparatorSets the symbol for decimal separators. Thousand SeparatorSets the symbol for thousand separators. In PercentShows formatting in percentage instead of absolute numbers. The setting is only available for Number, Integerand Fixed to. PreviewShows a preview of the number format specified above. |
Multi Box Properties: Presentation
Presentation
Style | Choose between the styles Borders and Light. | ||||||||||||||||
Text Align | Here you set the alignment of text field values in the list box. | ||||||||||||||||
Number Align | Here you set the alignment of numeric field values in the list box. | ||||||||||||||||
Sort by Applicability | Sorts the fields in the multi box according to whether they contain possible field values or not. Fields lacking possible field values are dynamically moved down if this check box is marked. | ||||||||||||||||
Grid Style |
Mark the check box if you want the grid style appearance for the multi box. |
||||||||||||||||
Limit Drop-down to | By marking this check box you can limit the length of opened drop-down list boxes in the multi box. Enter the maximum number of values to be shown in the edit box, or use the slider to set the desired value. | ||||||||||||||||
Background Color | Sets the background to a color, either a solid color or a gradient. Click ![]() |
||||||||||||||||
Background Image |
Sets an image as background. Click |
||||||||||||||||
More ../Less .. |
Style
|
Multi 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 ![]() |
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 CaptionSome options may not be available for all objects. MenuOpens the object menu. ClearClears 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 DataCopies the field values in the sheet object. Some clients may not handle this setting! Copy Image to ClipboardCopies the sheet object as an image to the Clipboard. Some clients may not handle this setting! Send to ExcelExports 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. Some clients may not handle this setting! Allow MinimizeWhen 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 MinimizeThis 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 MaximizeWhen 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 TextHere 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 Fast Type ChangeHere you can enable toggling between chart types. Not available for all objects. Click Fast Type Settings PopupCheck the boxes for the chart types you want to toggle between using fast type change. |
Multi 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 hidden when the condition returns false. The value may be entered as a calculated formula. Click ![]() |
||||||||
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
|