Grid Chart - AJAX/Webview
ON THIS PAGE
Grid Chart - AJAX/Webview
The grid chart is similar to the scatter chart but plots dimension values on the axes and uses an expression to determine the plot symbol. A special mode makes it possible to show a third dimension in the form of small pie charts as plot symbols.
Grid Chart: 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. |
Set Reference | By choosing this option you set a chart reference, i.e. a fixed plot of the chart with the current selections. When further selections are made in the document the reference plot remains, dimmed in the background. Chart axes etc will be adjusted to always include the maximum of the background data set and the current data set. The current data set is always plotted on top of the reference plot, i.e. some portions of the reference plot may be obscured by the current data set plot. The display of reference chart plots is only possible in some chart types, e.g. bar charts, line charts, combo charts, radar charts, scatter charts, grid charts and gauge charts with needles. It is not possible to set a reference for a chart that contains a drill-down or a cyclic group. The reference will be lost when closing the document or when reloading data. The maximum number of objects that can be included when using the Set Reference option is 500. |
Clear Reference | This command is replaced with the Set Reference command when a reference is set. By choosing it the previously set reference will be cleared and the chart will revert to normal plot mode. |
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. |
Print... |
Opens the selected sheet object(s) in tabular format in another browser window. Clicking on the |
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. Clicking on the |
Export... |
Opens the Save as dialog where path, file name and (table) file type for the exported data content can be specified. |
Fast Change |
Makes it possible to change the current chart into another chart type. Clicking on the |
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 |
Remove |
Removes the selected object from the sheet. |
Grid Chart 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.
Grid Chart Properties
Dimensions |
Choose dimensions in the drop-down list. To add a dimension, click DimensionsLimitsRestrict which values are displayed using the first expressionThese properties are used to determine how many dimension values are displayed in the chart, according to settings made below. Show onlySelect this option if you want to show the First, Largest or Smallest x number of values. If this option is set to 5, there will be five values displayed. If the dimension has Show Others enabled, the Others segment will take up one of the five display slots. Show only values that are:Select this option to display all dimensions values that meet the specified condition for this option. Select to display values based on a percentage of the total, or on an exact amount. The relative to the total option enables a relative mode which is similar to the Relative option on the Expressions tab of the property dialog. The value may be entered as a calculated formula. Click Show only values that accumulate to:When this option is selected,all rows up to the current row are accumulated, and the result is compared to the value set in the option. The relative to the total option enables a relative mode which is similar to the Relative option on the Expressions tab of the property dialog, and compares the accumulated values (based on first, largest or smallest values) to the overall total. The value may be entered as a calculated formula. Click Show OthersEnabling this option will produce an Others segment in the chart. All dimension values that do not meet the comparison criteria for the display restrictions will be grouped into the Others segment. If there are dimensions after the selected dimension, Collapse Inner Dimensions will control whether individual values for the subsequent / inner dimensions display on the chart. Show TotalThe chart will display a total for the selected dimension when this option is enabled. This total behaves differently than the expression total, which is still configured on the Expressions tab of the property dialog. Use Global Grouping ModeThe option only applies to inner dimensions. When this option is enabled the restrictions will be calculated on the selected dimension only. All previous dimensions will be ignored. If this is disabled, the restrictions are calculated based on all preceding dimensions. |
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 InvisibleHides the expression. Show in Percent (Relative)The chart shows the result in percent instead of absolute numbers. Show in LegendWhen several expressions are used, this option displays a legend showing the expressions and their corresponding colors next to the chart. Value Display SettingsCheck this box to define how to display values. Click Value Display Settings PopupText as PopupMark this check box to have the result of the expression shown in the popup balloon messages appearing when hovering over a data point in a chart in the layout. This option can be used with or without any of the other display options. It is thus possible to have an expression that does not appear in the chart itself, but only in hover popups. Attribute Expression Styles Background Color
|
Show Title | By default, the label of the first expression defined is set as chart title. Clear the check box if you do not wish to have a chart title. The title may be defined as a calculated formula for dynamic update. Click ![]() |
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. |
Grid Chart Properties: Presentation
Presentation
Look | Select one of the available looks in the drop-down. |
Autosize Symbols | Adjusts the maximum bubble size to the number of values in the chart. |
Symbol Size | Determines the size of symbols, if a symbol representation is specified. |
Max Bubble Size | Sets the size of the largest bubble in the chart. Available only for some looks and if Autosize Symbols is deselected. |
Show Legend | Displays the legend in the chart. Click ![]() |
Background |
Sets the background of the chart. The following options are available: Click Click |
Plot Area Background | Sets the background of the plot area. The following options are available: Color The plot area will have a colored background. Click ![]() ![]() Image The plot area will have an image background. Click ![]() ![]() Dynamic Image Click ![]() |
Plot Area Style | This control can be used to change the appearance of the plot area background. The following options are available: Frame A frame is drawn around the plot area. Shadow This options gives a shadow effect on the plot area background. Minimal The plot area background is removed. |
More.../Less... |
GeneralLabels on DatapointsCheck this box to display labels Max Values ShownIn this box, specify an upper limit for how many data points to show values for in the chart. If no limit is specified, values will be shown for all data points, which may affect the readability of the chart. Horizontal PositionSelect Left, Centered or Right for horizontal orientation of labels on datapoints. Vertical PositionSelect Above, Centered or Below for vertical orientation of labels on datapoints. Show X LabelDisplays a label at the end of the x-axis. Show Y LabelDisplays a label at the end of the y-axis. 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. Popup LabelsBy selecting this check box the values of the dimension(s) and expression(s) will appear as a pop-up balloon when hovering with the cursor over data point in the chart. HighlightIf this check box is marked hovering with the mouse over a line or symbol in it will result in the line or symbol being highlighted for better overview. The highlighting applies also in the legend where applicable. Show ArrowsDisplay options for arrows on connecting lines Arrows will be directed between scatter points in the sequential order defined by the sort order of the second field dimension. Check this alternative to have arrow heads displayed on the connecting lines. Arrow SizeThe size of the arrow heads. Arrow StyleSelect from several styles from the drop-down list. 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. displayed at any one time. Enter the maximum number of values. The value may be entered as a calculated formula. Click StylesLegendTo set the color of the legend click Chart Title Style To set the font color of the chart title 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. Reference LinesReference LinesAdd a reference line by clicking the Show Label in ChartDisplays the label next to the reference line. 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 X-AxisSelect this option if the reference line should originate from the x-axis. ExpressionThe value at which the reference line should be drawn. Enter an expression you wish to use as start point. Line WeightSpecifies the weight of the reference line. Line StyleSpecifies the style of the reference line. Line ColorSpecifies the color of the reference line. Use Show ConditionThe reference line will be shown or hidden depending on a conditional expression which will be evaluated each time the chart is to be drawn. The reference line will only be hidden when the expression returns FALSE. ConditionEnter the conditional expression. The value may be entered as a calculated formula. Click TextText in ChartClick TextThe text added in Text in Chart are displayed here. Tilt AngleSpecify an angle between 0 and 360 degrees for the text. The default is 0. Horizontal AlignSets the horizontal alignment. On TopThe text currently selected in the list will be forced to the foreground when drawing the chart. Text StyleTo set the background color for the text click Size PositionSets the position and size of the text on the object. |
Grid Chart 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. |
Grid Chart 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
|