List Box - AJAX/Webview

This is the most basic object on the screen. It contains a list of all the possible values of a specific field. In a list box you often make selections, and look at logical connections and implications.

A list box may also contain a cyclic or drill-down group. If a drill-down group is used, selecting a single value in the list box will cause the list box to drill down and switch to the next underlying field in the group. Drilling back up can be accomplished by clicking the drill-up icon in the list box caption.

If a cyclic group is assigned to a list box it can be made to show the next field in the group by clicking on the cycle icon that appears in the list box caption. It is also possible to go directly to any field in the group by using the Cycle-> option on the list box object menu.

List 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

Search Opens the text search box.
Fuzzy Search Opens the text search in fuzzy search mode.
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.

List 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 a field in the drop-down.
For more information click the More... button.

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 on top.

Number


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 Settings

Select 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 Pattern

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

Precision

The number of digits that will be displayed.

Decimals

Sets the number of decimals included.

Decimals Separator

Sets the symbol for decimal separators.

Thousand Separator

Sets the symbol for thousand separators.

In Percent

Shows formatting in percentage instead of absolute numbers. The setting is only available for Number, Integer and Fixed to.

Preview

Shows a preview of the number format specified above.

Hide Excluded

Toggles whether the excluded values of the field should be shown or not. Excluded values become unselectable as well.

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.
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.

Expressions

To add an expression click .Choose expression in the list. The icon moves the items in the list. The icon removes items from the list. The value may be entered as a calculated formula. Click to open the Edit Expression dialog. Click to open the Expression Settings dialog.

Enable

Marking this check box will enable the selected expression. If the box is not marked, the expression will not be used at all.

Conditional

The column will be displayed or hidden depending on a condition expression which will be evaluated each time the object is drawn. The value may be entered as a calculated formula.

Expression

Enter the expression you wish to display. The value may be entered as a calculated formula. Click to open the Edit Expression dialog.

Data (Numeric)

Sets the alignment for numeric data to Left, Centered or Right.

Data (Text)

Sets the alignment for text data to Left, Centered or Right.

Representation

Choose a representation in the drop-down list. Depending on which representation is chosen different settings are shown.

Text
No other settings.

Image
When Image is selected, settings can be made for Image Stretch:
No Stretch
Displays the image without stretching. This may cause parts of the picture to be invisible or only part of the object to be filled.
Fill
The image is stretched to fit the object area without keeping the aspect ratio of the image.
Keep Aspect
The image is stretched as far as possible to fill the object area while keeping the aspect ratio.
Fill with Aspect
The image is stretched to fill the object area in both directions while keeping the aspect ratio.

Gauge
Different gauge styles are available. The gauge chart will be inscribed in the available table cell. Settings for the different gauge alternatives:
Min
Specifies the minimum value of the gauge. The value may be entered as a calculated formula. Click to open the Edit Expression dialog.
Max
Specifies the maximum value of the gauge. The value may be entered as a calculated formula. Click to open the Edit Expression dialog.

Mini Chart
When selecting this option, QlikView will display the expression value in a miniature chart with the expression aggregated over an extra dimension. The chart will be inscribed in the available table cell. The mini chart dimension can be defined as well as visual settings.
Settings for the Mini Chart:
Field
Choose the field for which the expression should be plotted.
Mode
Set the mini chart as sparklines, lines, dots, bars or whiskers.

Note: The mini chart will not be displayed when exporting to Excel!


List Box Properties: Presentation

Presentation

Selection Style Sets the selection style for the document. Select between the available alternatives in the drop-down menu. By choosing <User Default> the document will always be opened with the selection style set as preferred by the user under User Preferences on the computer where it is opened.

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.

Image Settings Popup

Image Stretch
No Stretch 
Displays the image without stretching. This may cause parts of the picture to be invisible or only part of the object to be filled.
Fill 
The image is stretched to fit the object area without keeping the aspect ratio of the image.
Keep Aspect 
The image is stretched as far as possible to fill the object area while keeping the aspect ratio.
Fill with Aspect 
The image is stretched to fill the object area in both directions while keeping the aspect ratio.

Hide Text When Image is Missing
No text will be displayed if QlikView cannot interpret the image reference.


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.

Text AlignHere you set the alignment of text field values in the list box.
Number AlignHere you set the alignment of numeric field values in the list box.
Auto Columns

The number of columns is automatically selected.

Fixed Number of ColumnsIf multiple columns are allowed, specify the number of columns in the input field, or drag the slider to the desired number.
Background ColorSets 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...

General

Show as TreeView

Shows the list box as a tree view. This control is only relevant if the field contains the path representation of nodes in a hierarchy. Such a field can be generated using the Path parameter of the Hierarchy prefix.

With Separator

Sets the character that should be interpreted as separator in the path used for the Tree View.

Search Mode

Default 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.

Suppress Horizontal Scrollbar

Check this option to suppress the horizontal scrollbar that is normally displayed when field values are too wide to for the specified width of the list box. Instead, field values will be truncated as needed.

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 Borders

The field values will be separated by horizontal lines, resembling the rows of a table. Cell borders are automatically activated when the Wrap Cell Text option is checked, but may be subsequently deactivated.

Wrap Cell Text

With this option selected, a cell will display its contents in more than one row.

Cell Rows

Set the number of cell rows.

Print All Values

The normal print behavior for list boxes is to print only possible values. By marking this check box, all values (also excluded values) will be printed.

Layout Dependent Print

By marking this check box, the list box will be printed as it appears on the screen in terms of multiple columns, selection color coding of cells etcetera. This may be useful e g when including list boxes in reports.

Null Symbol

The symbol entered here will be used for displaying null values in the object.

Missing Symbol

The symbol entered here will be used for displaying missing values in the object.

Style

Text

To set the font type click .

Caption Font

To set the caption font 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.

Rounded Corners Popup

Select

Fixed

or

Relative

roundness of the corners, and which corners to be affected. Also select

Squareness

by entering a value. 

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.

 

List Box Properties: Caption

Caption

LabelIn 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 CaptionWhen 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 AlignmentLeft/Centered/Right
Multi Line Caption (Word Wrap)If this option is checked, the text will be displayed in two or more rows.
Number of RowsIf 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 AlignmentTop/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.

List Box Properties: Options

Options

Some options may not be available for all objects.

Read OnlyMakes the chart read only, that is selections cannot be made by clicking or painting with the mouse in the chart.
Allow Move/SizeIf this option has been deselected it will be impossible to move or resize the sheet object.
Allow Copy/CloneIf 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 DataNormally 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 CaptionWhen 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 PositionWhen 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 ConditionThe 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.
NormalSpecify the position of the object by setting Left and Top margins, and Width and Height of the object.
MinimizedSpecify the position of the minimized sheet object by setting Left and Top margins, and Width and Height of the minimized object.
More.../Less...

Options

OwnerDomain and User Id of the owner.
Share ObjectEnable to share objects with other users. Enabling this selection will enable the settings below.
Share withChoose 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?