Multi Box Properties

Field To add an item click . Select a field in the drop-down. The icon moves the items in the list. The icon removes items from the list. The object will contain the values of the selected field.
For more information click the More... button.

Field

Field

Select a field in the drop-down.

Label

Enter the label name. The value may be entered as a calculated formula. Click to open the Edit Expression dialog.

Representation

Text
When selecting this option, the field values will always be interpreted and displayed as text.

Image
When selecting this option QlikView will try to interpret each field value as a reference to an image. The reference may be a path to an image file on disk (e.g. C:\Mypic.png) or inside the qvw document (e.g. qmem://<Name>/<Peter>). If QlikView cannot interpret a field value as a valid image reference, the value itself will be displayed. Click to open the Image Settings popup.


Info as Image
When selecting this option QlikView will display image info linked to the field value via info load/select in the script. If no image is available for the field value, the value itself will be displayed, unless the Hide Text When Image Missing box is checked.

Search Mode

Here you may determine the default search mode, Wildcard, Fuzzy, Normal and Associative, to be used in any text search.

Include Excluded Values in Search

The 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 Settings

Click to open the popup.

Dropdown Select Settings Popup

Ignore Null

NULL-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 to open the popup.

Dropdown Select Alignment Popup

Number Align

Here 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 to open the popup.

Rows and Columns Popup

Single Column

With 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 Border

is automatically activated when the

Wrap Text

option is checked, but may be consequentiality deactivated.

Sort

Sets 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 Sort

Y-Value
Sets whether the dimension values should be sorted according to the numeric value of the y-axis. This option is not available for calculated dimensions.
Frequency
Sorts the field values by frequency (number of concurrences in the table).
Numeric Value
Sorts the field values by their numeric values.
Text
Sorts the field values in alphabetical order.
Load Order
Sorts the field values by the initial load order.

Secondary Sort

Frequency
Sorts the field values by frequency (number of concurrences in the table).
Numeric Value
Sorts the field values by their numeric values.
Text
Sorts the field values in alphabetical order.
Load Order
Sorts the field values by the initial load order.

Sort by Expression

Sorts the field values according to the expression entered. The value may be entered as a calculated formula. Click to open the Edit Expression dialog.

Keep Selected on Top

Enable this to keep the selected values on top.

Number Format


Each 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

Precision

field.


Integer

Shows numeric values as integers.


Fixed to

Shows numeric values as decimal values with the number of decimal digits set in the

Decimals

field.


Money

Shows values in the format set in the

Format Pattern

field. The default format is the Windows Currency setting.


Date

Shows values that can be interpreted as dates in the format set in the

Format Pattern

field.


Time

Shows values that can be interpreted as time in the format set in the

Format Pattern

field.


Timestamp

Shows values that can be interpreted as date + time in the format set in the

Format Pattern

field.


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.

ISO

sets the format to the ISO standard. Only valid for

Date

,

Time

,

Timestamp

and

Interval

.

Sys

sets 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

,

Integer

and

Fixed to

. PreviewShows a preview of the number format specified above.

 

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?