Gauge Chart - AJAX/Webview

Gauge charts are used to display the value of a single expression without dimensions.

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

Notes and Comments

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 icon in the object caption (if shown) produces the same result.

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

Fast Change

Makes it possible to change the current chart into another chart type. Clicking on the icon in the object caption (if shown) produces the same result. Only available if Fast Type Change in Chart has been enabled on the Caption tab of the Properties dialog.

Minimize

Iconizes the object. Clicking on the icon in the object caption (if shown) produces the same result. This command is available only if minimizing is allowed in the object's Properties dialog on the Caption page.

Restore

Restores a minimized or maximized object to its previous size and location. Double-clicking the icon of a minimized object or clicking the icon in the object caption (if shown) of a maximized object produces the same result. This command is available only for minimized or maximized objects.

Maximize

Enlarges the object to fill the sheet. Clicking on the icon in the object caption (if shown) produces the same result. This command is available only if maximizing is allowed in the object's Properties dialog on the Caption page.

Remove

Removes the selected object from the sheet.

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

Expressions

Choose expressions in the drop-down list. To add an expression, click . Select an expression from the drop-down. Use the icon to move items in the list. The icon removes items from the list. For more information click the More... button.

Expression

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

Marking this check box hides or shows the expression dynamically, depending on the value of a condition expression entered, by clicking the button in the edit box below.

Label

The 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 to open the Edit Expression dialog.

Expression

Displays the currently selected expression.

Comment

Enter a comment to describe the purpose and function of the expression. The value may be entered as a calculated formula. Click to open the Edit Expression dialog.

 
Actions Choose actions in the drop-down list. To add an action, click . Select an action from the drop-down. Use the icon to move items in the list. The icon removes items from the list. Click to open the Action Settings popup.

Action Settings Popup

Select action

Type

and

Subtype

in the drop-down lists:

Selection

Select in Field

Selects the values and fields that are specified. In the Search String you can specify a search mask, e.g. (A|B) will select both A and B.

Select Excluded

Selects the excluded values in the specified field.

Select Possible

Selects the possible values in the specified field.

Toggle Select

Toggles between the current selection and the specified Field and Search String. In the Search String you can specify a search mask, e.g. (A|B) will select both A and B.

Forward

Goes one step forward in the list of selections.

Back

Goes back one step in the list of selections.

Pareto Select

Makes a pareto selection in the specified field based on an expression and percentage. This type of selection is used to select the top contributors to a measure, typically in line of a general 80/20 rule. For example, to find the top customers that contribute to 80% of the turnover, Customer should be used as field, sum(Turnover) should be used as expression and 80 should be used as percentage.

Lock Field

Locks the selections in the specified field.

Lock All

Locks all values in all fields.

Unlock Field

Unlocks the selections in the specified field.

Unlock All

Unlocks all values in all fields.

Unlock and Clear All

Unlocks all values and clears all selections in all fields.

Clear Other Fields

Clears all related fields except the one specified.

Clear All

Clears all selections except locked ones.

Clear Field

Clears a specific field.

Layout

Activate Object

Activates the object specified by Object ID. This function does not work in Ajax client.

Activate Sheet

Activates the sheet specified by Sheet ID.

Activate Next Sheet

Opens the next sheet in the document.

Activate Previous Sheet

Opens the previous sheet in the document.

Minimize Object

Minimizes the object specified by Object ID.

Maximize Object

Maximizes the object specified by Object ID.

Restore Object

Restores the object specified by Object ID.

Bookmark

Apply Bookmark

Applies a bookmark specified by Bookmark ID. If two bookmarks have the same ID, the document bookmark is applied. To apply the server bookmark specify Server\bookmarkID. 

Create Bookmark

Creates a bookmark from the current selection. Specify Bookmark ID and Bookmark Name. Select Hidden to create a hidden bookmark.

Replace Bookmark

Replaces the bookmark specified by Bookmark ID with the current selection.

Print

Print Object

Prints the object specified by Object ID. Specify the Printer name if the object should be sent to another printer than the default printer. (Not available as document and sheet trigger.)

Print Sheet

Prints the sheet specified by Sheet ID. (Not available as document and sheet trigger.) This function does not work in AJAX client.

Print Report

Prints the report specified by Report ID. Specify the Printer name if the report should be sent to another printer than the default printer. Mark the check box Show Print Dialog if you want the Windows print dialog to be shown. (Not available as document and sheet trigger.)

External

Some clients may not handle this setting!

Export

Exports a table containing a specific set of fields, but only those records that are applicable according to the made selection are exported. Click on the Setup button on the Actions page to open the Export Action Settings dialog. (not available as document and sheet trigger)

Launch

Launches an external program. The following settings can be configured in the Actions dialog:
Application
Click on Browse... to find the application that should be launched. (Not available as document and sheet trigger.)
Filename
Enter the path to the file that should be opened with the application specified above. (Not available as document and sheet trigger.)
Parameters
Specify parameters for the command line from which the application is started. (Not available as document and sheet trigger.)
Working Directory
Sets the working directory for the application to be launched. (Not available as document and sheet trigger.)
Exit application when QlikView is closed
Forces the application to be closed when QlikView is exited. (Not available as document and sheet trigger.)
This function does not work in AJAX client.

Open URL

Opens the URL in the default web browser. (Not available as document and sheet trigger.)

Open QlikView Document

Opens the specified document. The file extension must be included. (Not available as document and sheet trigger.)
Mark the check box Transfer State to transfer the selections from the original document to the one you wish to open. The opened document will first be cleared of selections.
Mark Apply state on top of current to retain the second document’s selections and apply the original document’s selections on top of them.

Note: Use Apply state on top of current with caution, as it can cause unpredictable results if the two documents selections are conflicting. In most cases it should be sufficient with using the Transfer State option.

Open in same Window opens the new document in the same browser tab when using the AJAX ZFC client.

Note: Open QlikView Document action is not supported for non domain users when using the Internet Explorer plugin

Run Macro

Enter the path and name of the macro to be run. Type any name for which it is possible to later create a macro in the Edit Module dialog, or a calculated expression for dynamic update.

Set Variable

Assigns a value to the specified variable.

Show Information

Shows the associated information, such as a text file or an image for the field specified by Field. This function does not work in AJAX client.

Close This Document

Closes the active QlikView document.

Reload

Performs a reload on the current document. This function does not work both in AJAX client and IE-plugin.

Dynamic Update

Performs a dynamic update of the data in the currently loaded document. The statement for the dynamic update is to be entered in the Statement field.

The intended usage of Dynamic Update allows a QlikView Administrator to feed limited amounts of data in to a QlikView document from a single source without running a reload of the document. Analysis can then be performed by multiple clients connecting to the QlikView Server.

Note! The uploaded information is stored in RAM only so any data added or updated using Dynamic Update will be lost if a reload of the document is performed.

The following grammar describes the possible statements and their components that can be used with the Dynamic Update feature:

  • statements ::= statement { “;” statement }
  • statement ::= insert_statement | update_statement | delete_statement | begin_transaction_statement | commit_transaction_statement
  • insert_statement ::= "INSERT" "INTO" ("*" | table_name) field_list "VALUES" value_list {"," value_list} ["KEY" ["AUTO" | (" (" field_list ")")] ["REPLACE" (["WITH" "ONE"] | "EACH") ]]
  • update_statement ::= "UPDATE" ("*" | table_name) set_clause {"," | set_clause} "WHERE" condition ["AUTO" "INSERT"]
  • delete_statement ::= "DELETE" "FROM" ("*" | table_name] "WHERE" condition
  • begin_transaction_statement ::= "BEGIN" ("TRANSACTION" | "TRAN") [trans_name]
  • commit_transaction_statement ::= "COMMIT" ["TRANSACTION" | "TRAN"] [trans_name]
  • table_name ::= identifier | quoted_name
  • field_list ::= "(" field_name {"," field_name} ")"
  • value_list ::= "("value {"," value} ")"
  • set_clause ::= "SET" field_name "=" any_valid_non_aggregated_qlikview_expression
  • field_name ::= identifier | quoted string
  • value ::= identifier | any_qlikview_number | quoted string
  • condition ::= any_valid_non_aggregated_qlikview_expression
  • identifier ::= any_qlikview_identifier
  • quoted_string ::= "[" [^]]+ "]"

Example:  

UPDATE AbcTable SET Discount = 123 WHERE AbcField=1

Note: To use this feature, Dynamic Update must be allowed both on the Document and on the Server.
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. The value may be entered as a calculated formula. Click to open the Edit Expression dialog.
More.../Less... Click this button to expand/collapse the foldout that contains additional tabs.

Gauge Chart Properties: Presentation

Presentation

Look Select one of the available looks in the drop-down.
Gauge Min Specifies the minimum value of the gauge. This corresponds to the bottom position of the gauge indicator.
Gauge Max Specifies the maximum value of the gauge. This corresponds to the top position of the gauge indicator.
Gauge Segment Settings In this group you define the segments making up the gauge. All gauges except LED style gauges must have at least one segment. For circular and linear gauges the segments make up differently colored areas in the gauge background. For traffic light gauges each segment corresponds to one light. A list of segments is shown and you may select one segment in the list to change its properties.

Select a segment in the drop-down, to add a segment click . Click to select a color on the bound. Click to remove items from the list. Click to open the popup.

Gauge Segment Settings Popup

Autowidth Segments

If this check box is marked, the segment bounds will be calculated automatically based on the gauges Min value, Max value and the number of segments defined.

Logarithmic Scale

If this check box is marked, the gauge scale will be logarithmic.

Relative Segment Limits

If this option is selected the segment bounds can be entered as numbers between 0 and 1 indicating a fraction of the total range between the Min and Max values.

Show Segment Outlines

Shows the outlines of the gauge segments

Show Segment Boundaries

If this check box is marked outlines will be made in the segment boundaries of circular and linear gauges.

Segments Click to add segments to the gauge.
Background Sets the background of the chart. The following options are available:

Color
Click to select a color.

Image
Click to change the image.

Dynamic Image
Enter a calculated expression to show dynamic background images that change with the selection.
Background Transparency Enter a value in the box or drag the slider to set transparency for the chart.
More.../Less...

General

General Tab Speedometer and Circular Look

Show Gauge Indicator

Shows the gauge value by means of a needle indicator.

Indicator Style

Specifies the style of the needle.

Fill Gauge to Value Only

Shows the gauge value by means of filling the gauge background with the defined segment color(s) only up to the current value. The remaining part up to the Max value is left blank.

Show Gauge Scale

Select this check box to show a scale.

No. of Major Units

Defines the number of major units on the gauge scale.

No. of Minor Units

Defines the number of minor units between each major unit on the gauge scale.

Show Gauge Labels

Select this check box to show text labels on the gauge scale.

Label Frequency

The density of labels can be entered in the edit box.

Cylinder Thickness

The gauge is normally drawn as a solid circle or circle segment. The greater the number here, the thicker the cylinder. The value which indicates the percentage of the radius to be left unfilled must be between 0 and 99.

Angle Span

The angle in degrees between the Min and Max values in the gauge. Must be a value between 45 and 360.

Center Angle

The angle of the gauge’s center value in relation to the clock. Must be a value between 0 and 360. 0 indicates the center at the top of the gauge (12 o’clock).

Popup Labels

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

General Tab Straight Gauge Look

Show Gauge Indicator

Shows the gauge value by means of a needle indicator.

Indicator Style

Specifies the style of the needle

Fill Gauge to Value Only

Shows the gauge value by means of filling the gauge background with the defined segment color(s) only up to the current value. The remaining part up to the Max value is left blank.

Show Gauge Scale

Select this check box to show a scale.

No. of Major Units

Defines the number of major units on the gauge scale.

No. of Minor Units

Defines the number of minor units between each major unit on the gauge scale.

Show Gauge Labels

Select this check box to show text labels on the gauge scale.

Label Frequency

The density of labels can be entered in the edit box.

Popup Labels

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

General Tab Traffic Light Look

Single Light

Checking the box displays only one light.

Indicator Style

Specifies the style of the area surrounding the lights

Fill Gauge to Value Only

Shows the gauge value by means of filling the gauge background with the defined segment color(s) only up to the current value. The remaining part up to the Max value is left blank.

Reverse Direction

Checking the box displays the lights in reversed order.

Popup Labels

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

General Tab LedStyle Look

Digits

Choose how many digits there should be.

Digit Color

To set the color click .

Popup Labels

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

General Tab Test Tube Look

Test Tube Color

To set the color click .

Show Gauge Scale

Select this check box to show a scale.

No. of Major Units

Defines the number of major units on the gauge scale.

No. of Minor Units

Defines the number of minor units between each major unit on the gauge scale.

Show Gauge Labels

Select this check box to show text labels on the gauge scale.

Label Frequency

The density of labels can be entered in the edit box.

Popup Labels

By selecting this check box the values of the dimensions and expressions will appear as a pop-up balloon when hovering with the cursor over data point in the chart.

General Tab Reflected Tube Look

Show Gauge Scale

Select this check box to show a scale.

No. of Major Units

Defines the number of major units on the gauge scale.

No. of Minor Units

Defines the number of minor units between each major unit on the gauge scale.

Show Gauge Labels

Select this check box to show text labels on the gauge scale.

Label Frequency

The density of labels can be entered in the edit box.

Popup Labels

By selecting this check box the values of the dimensions and expressions will appear as a pop-up balloon when hovering with the cursor over data point in the chart.

Styles

Chart Title Style

To set the font color of the chart title click . To set the font type click .

Scale Label

To set the font type click .

Caption Font

To set the caption font type 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 the to set the color of the border.

Border Width

Specify a value or drag the slider to set the width of the border. The width is specified in pixels.

Rounded Corners

Click to open the Rounded Corners popup.

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

Squareness

by entering a value. 

Reference Lines

Reference Lines

Add a reference line by clicking the .

Show Label in Chart

Displays the label next to the reference line.

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.

X-Axis

Select this option if the reference line should originate from the x-axis.

Expression

The value at which the reference line should be drawn. Enter an expression you wish to use as start point.

Line Weight

Specifies the weight of the reference line.

Line Style

Specifies the style of the reference line.

Line Color

Specifies the color of the reference line.

Use Show Condition

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

Condition

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

Text

Text in Chart

Click to add text in the chart.

Text

The text added in Text in Chart are displayed here.

Tilt Angle

Specify an angle between 0 and 360 degrees for the text. The default is 0.

Horizontal Align

Sets the horizontal alignment.

On Top

The text currently selected in the list will be forced to the foreground when drawing the chart.

Text Style

To set the background color for the text click .
To set the font color click . To set the font type click .

Size Position

Sets the position and size of the text on the object.

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

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

Options

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.

 

 

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?