Pivot Table - AJAX/Webview
ON THIS PAGE
Pivot Table - AJAX/Webview
The pivot table is one of the most powerful tools for analyzing data. It offers substantial functionality but is still easy to use. Pivot tables show dimensions and expressions in rows and columns, for example in cross tables. The data in pivot tables may be grouped. Pivot tables can show partial sums.
After a reload, any expanded columns in a pivot table will be collapsed.
Pivot Table: 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. |
Detach | The chart title is appended with the text “(Detached)” and the chart is no longer updated with selections made in the document (though selections may actually still be made from the chart). The command is available only if the chart is attached. By making a copy of a chart and detaching it, you may make direct comparisons between the copy and the original. |
Attach | Attaches a detached chart. The chart becomes dynamically linked to the data. The command is available only if the chart is detached. |
Expand All | Expands all expandable cells. |
Collapse All | Collapses all collapsible cells. |
Collapse Dimension Rows | Collapses all dimension rows. |
Collapse Dimension Columns | Collapses all dimension columns. |
Clear All Selections |
Clears all the current selections in the active sheet object. Clicking on the |
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. |
Minimize |
Iconizes the object. Clicking on the |
Restore |
Restores a minimized or maximized object to its previous size and
location. Double-clicking the icon of a minimized object or clicking the |
Maximize |
Enlarges the object to fill the sheet. Clicking on the |
Delete |
Removes the selected object from the sheet. |
Pivot Table 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.
Dimensions |
Choose dimensions in the drop-down list. To add a dimension, click DimensionEnable ConditionalMarking this check box hides or shows the dimension dynamically, depending on the value of a condition expression entered, by clicking the DimensionDisplays the currently selected dimension. LabelThe label of the dimension. Enter the name you wish to display in the chart. If no text is entered, the label will be automatically set to the expression text. The value may be entered as a calculated formula. Click Suppress Null ValuesIf this check box is marked, the field selected as Dimension above will not be displayed in the chart if its value is NULL. Show All ValuesMark this check box to show all the dimension field values in the chart, including logically excluded values. Dropdown SelectIf this check box is selected for a field column, a drop-down icon will appear to the left in 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. Show Partial SumsDisplays partial sums in the sheet object. Column AlignmentClick Column Alignment PopupLabelSets the alignment for the label to Left, Centeredor Right. Data (Numeric) Sets the alignment for the horizontal label to Left, Centeredor Right. Data (Text) Sets the alignment for text data to Left, Centeredor Right. Attribute Expression StylesBackground Color
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 Sort Y-ValueSets 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 FrequencySorts 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![]() Keep Selected on Top Enable this to keep the selected values on top. |
Expressions |
Choose expressions in the drop-down list. To add an expression, click ExpressionEnableMarking this check box will enable the selected expression. If the box is not marked, the expression will not be used at all. ConditionalMarking this check box hides or shows the expression dynamically, depending on the value of a condition expression entered, by clicking the LabelThe label of the expression. Enter the name you wish to display in the chart. If no text is entered, the label will be automatically set to the expression text. The value may be entered as a calculated formula. Click ExpressionDisplays the currently selected expression. CommentEnter a comment to describe the purpose and function of the expression. The value may be entered as a calculated formula. Click RepresentationChoose a representation in the drop-down list. Depending on which representation is chosen different settings are shown.Text No other settings. Image Click ![]() Gauge Settings for the different gauge alternatives: Gauge Min Specifies the minimum value of the gauge. The value may be entered as a calculated formula. Click ![]() Gauge Max Specifies the maximum value of the gauge. The value may be entered as a calculated formula. Click ![]() Mini Chart Field Choose the field for which the expression should be plotted. Click ![]() Link No other settings. Column AlignmentClick Column Alignment PopupLabelSets the alignment for the label to Left, Centeredor Right. Data (Numeric) Sets the alignment for the horizontal label to Left, Centeredor Right. Data (Text) Sets the alignment for text data to Left, Centeredor Right. Visual CuesClick Visual Cues PopupUpper LimitSettings for the upper numeric interval value category. The numeric value above which the upper interval of numeric values begins is stated in the edit box. If this box is left empty no upper interval is defined. Normal Settings for the normal numeric interval value category. This interval is defined as all values between the upper limits and lower limits. By default, all numeric values fall within the normal interval. Lower Limit Settings for the lower numeric interval value category. The numeric value below which the lower interval of numeric values begins is stated in the edit box. If this box is left empty no lower interval is defined. Attribute Expression StylesBackground Color |
More.../Less... | Click this button to expand/collapse the foldout that contains additional tabs. Depending on if the Dimensions or Expressions field is active, different tabs are displayed. |
Pivot Table Properties: Presentation
Presentation
Indent Mode | If this check box is marked, the pivot table’s left (column) dimensions will be displayed in indent mode. This means that the dimension values will replace the “Total“ label, allowing for a compact display with just small indents between dimensions. |
Use Only First Dimension Label | This setting is only meaningful when a pivot table is in indent mode. By marking this check box the dimension label for the first dimension will occupy the entire label row. Dimension labels for subsequent dimensions will not be shown. |
Always Fully Expanded | If this check box is selected, all the dimensions are always fully expanded, and the expand/collapse functionality is turned off. |
Suppress Expansion Icons in Print | Select this check box if you do not want the ‘+’ and ‘-’ icons for partial expand and collapse to be visible when printing the pivot table. |
Selection Indicators | Displays selection indicators (beacons) in the table columns containing fields with selections. |
Populate Missing Cells | When this check box is marked, cells in cross tables representing missing combinations of dimensions will be mapped to a regular null value. Thereby it becomes possible to apply expressions testing for null and for attribute expressions and style formats to be applied. |
Total Position | Settings for display of totals in the pivot table. |
Allow Move Column and Pivoting | Deselect this check box to disable the drag-and-drop pivoting. |
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... |
GeneralStyleChoose an appropriate style from the drop-down list. Cell BordersClick Cell Border Settings PopupVertical Dimension Cell BordersIf this check box is deselected all vertical cell borders in dimension cells of the current style will be removed. Vertical Expression Cell Borders If this check box is deselected all vertical cell borders in expression cells of the current style will be removed. Border Above Spacing If this check box is marked dimension spacing rows will be preceded by the same horizontal borders as those below. Furthermore all vertical borders will be removed within the spacing area. Suppress Zero-ValuesIf this check box is marked, all combinations of the dimension fields returning zero or null from all expressions will be disregarded in the calculation. This option is selected by default. Suppress MissingIf this check box is marked, all combinations of the dimension fields associated with only null values in all fields in all expressions will be disregarded in the calculation. This option is selected by default. Turning it off can be useful only in special cases, e.g. if null values is to be counted in a chart. Selection IndicatorsDisplays selection indicators (beacons) in the table columns containing fields with selections. Vertical LabelsDisplays the column titles vertically. Null SymbolThe symbol entered here will be used for displaying NULL values in the table. Missing SymbolThe symbol entered here will be used for displaying missing values in the table. Wrap HeaderThe contents of the header will be wrapped in two or more lines. Wrap Cell TextThe contents of the data cells will be wrapped in two or more lines. Calculation ConditionsThe expression entered here sets a condition to be fulfilled for the chart to be calculated. If the condition is not fulfilled, the text 'Calculation condition unfulfilled' will be displayed in the chart. The value may be entered as a calculated formula. Click StylesFontTo set the font type click
Caption FontTo set the caption font type click Active CaptionTo to set the background color for the active caption click Inactive CaptionTo to set the background color for the inactive caption click Use BorderMark this check box in order to use a border around the sheet object. Click the Border WidthSpecify a value or drag the slider to set the width of the border. The width is specified in pixels. Rounded CornersClick Note:
Rounded Corners is only available if you have selected Advanced Styling Mode in Document Properties: General. Rounded Corners PopupSelect Fixedor Relativeroundness of the corners, and which corners to be affected. Also select Squarenessby entering a value. Scroll Bar WidthSpecify a value or drag the slider to set the width of the scroll bar. This control affects both the width and the relative size of the scroll bar symbols. |
Pivot Table 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. |
Pivot Table 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
|