Removes the selected object from the sheet.

Actions Settings Popup

Type
Choose a Type in the drop-down list.
Subtype
Choose a Subtype in the drop-down list. The subtypes available depend on the Action Type chosen.

Actions Types and Actions

Action Types and Actions

Selection

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.

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

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

Styles

Text	To set the text color click . 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 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. 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.

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.

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.