Table Box - AJAX/Webview

The table box is a sheet object that shows several fields simultaneously. The content of every row is logically connected. The columns may be fetched from different internal tables, letting the user create tables from any possible combination of fields.

By right-clicking the object, the Object Menu will be displayed.

The Table 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:

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

Column Fields

Select a field in the drop-down.

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: The field that is currently edited.
• Label: Enter the label name. The value may be entered as a calculated formula. Click to open the Edit Expression dialog.
• Label Align: Set the alignment of the label in the table box.

• Representation: This section describes Representation options.
  • 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 QlikView 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:
    • 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 through 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.

• Number Align: Set the alignment of numeric field values in the table box.
• Text Align: Set the alignment of text field values in the table box.
• Ignore Null: NULL-values are not considered for the sake of displaying possible values of a specific field.
• Dropdown Select: If this check box is selected for a field column, a drop-down icon will appear to the left of the column header. By clicking the icon, a list box showing all field values of the field will be opened over the table. It is then possible to make selections and searches in the same manner as if the field had been a row in a multi box.
• 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.

  Information note

  Associative is available as a search mode for list boxes only.

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

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.

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 the 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.
• 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. This setting is only available for Number, Integer, and Fixed to.
• Preview: Shows a preview of the number format specified above.

Table Box Properties: Presentation

This section describes Table Box properties.

Suppress Header Row

Displays the table without header (label) row.

Sort Indicators

Displays a sort indicator icon (arrow) in the header of the column. The direction of the icon indicates whether the column is sorted ascending or descending.

Selection Indicators

Displays selection indicators (beacons) in the table columns containing fields with selections.

Allow Move Column

Deselect this check box to disable moving columns.

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.

Image Popup

• 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.
• Horizontal: Left, Centered or Right alignment.
• Vertical: Top, Centered or Bottom alignment.
• Transparency: Set the level of transparency by entering a value or by dragging the slider. At 100% the background will be completely transparent.

More.../Less...

This section describes More.../Less... properties.

General

• Style: Choose an appropriate style from the drop-down list.
• Stripes every _ Rows: Specify if and how long intervals in rows, shaded stripes should appear.
• Vertical Labels: Displays the column titles vertically.
• Wrap Header: The contents of the header will be wrapped in two or more lines.
• Wrap Cell Text: The contents of the data cells will be wrapped in two or more lines.

Style

• Font: To set the font type click .
• Active Caption: To set the background color for the active caption click . To set the text color click .
• Inactive Caption: To set the background color for the inactive caption click . To set the text color click .
• Scroll Bar Background: To set the scroll bar background color click .
• Scroll Bar Slider: To set the scroll bar slider color click .
• 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.
• 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.
  Information note

  Rounded Corners is only available if you have selected Advanced Styling Mode in Document Properties: General.

  • Rounded Corners Popup: Select Fixed or Relative roundness of the corners, and which corners to be affected. Select Squareness by entering a value.

Table Box Properties: Caption

Caption

This section describes Caption properties.

• 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: Can be Left, Centered, or 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: Can be Top, Centered, or Bottom.

More.../Less...

This section describes More.../Less... properties.

Icons in Caption

• 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 2007 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 Minimize: 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.

Table 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 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...: The following options are available:
  • 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.