Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

RE:Actions&Triggers

hi guys,

can anyone provide  Actions &triggers  .Qvw  files..or material

thnks.

Suresh

1 Solution

Accepted Solutions
mohammadkhatimi
Partner
Partner

Actions

On this page actions can be set for certain objects:

  • buttons
  • text objects
  • gauges
  • line/arrow objects

Actions include launching an external application or exporting data from QlikView.

   

AddOpens the Add Action Dialog where the actions for the object are chosen. Choose the type of action in the lists. Depending on the action, different parameters for the action will appear on the Actions page. The actions will be executed in the order in which they appear in the list.
DeleteRemoves the action from the object.
PromoteMoves the selected action up in the list of actions.
Alternate StateSets the state that the action refers to. This setting is only relevant for actions related to selections or bookmarks

Add Action Dialog

The following actions can be added from the Add Action dialog. In all fields with the ... button it is possible to enter a calculated formula, see Calculated Formula.

Selection

   

Select in FieldSelects 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 ExcludedSelects the excluded values in the specified field.
Select PossibleSelects 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.
ForwardGoes one step forward in the list of selections.
BackGoes back one step in the list of selections.
Pareto SelectMakes 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 FieldLocks the selections in the specified field.
Lock AllLocks all values in all fields.
Unlock FieldUnlocks the selections in the specified field.
Unlock AllUnlocks all values in all fields.
Unlock and Clear AllUnlocks all values and clears all selections in all fields.
Clear Other FieldsClears all related fields except the one specified.
Clear AllClears all selections except locked ones.
Clear FieldClears a specific field.
Copy State ContentsCopies the selection from the Source State to the Target State. Only available when alternate states have been defined.
Swap State ContentsSwaps the selections between State 1 and State 2. Only available when alternate states have been defined.

Layout

   

Activate ObjectActivates the object specified by Object ID. This function does not work in Ajax client.
Activate SheetActivates the sheet specified by Sheet ID.
Activate Next SheetOpens the next sheet in the document.
Activate Previous SheetOpens the previous sheet in the document.
Minimize ObjectMinimizes the object specified by Object ID.
Maximize ObjectMaximizes the object specified by Object ID.
Restore ObjectRestores the object specified by Object ID.
Set State NameApplies the specified State to the object specified by Object ID. Only available when having defined alternate states.

Bookmark

   

Apply BookmarkApplies 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 BookmarkCreates a bookmark from the current selection. Specify Bookmark ID and Bookmark Name. Select Hidden to create a hidden bookmark.
Replace BookmarkReplaces the bookmark specified by Bookmark ID with the current selection.

Print

   

Print ObjectPrints 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 SheetPrints the sheet specified by Sheet ID. (Not available as document and sheet trigger.) This function does not work in AJAX client.
Print ReportPrints 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

   

ExportExports 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)
LaunchLaunches 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 URLOpens 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 when using the Internet Explorer plugin

Run MacroEnter 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 VariableAssigns a value to the specified variable.
Show InformationShows 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 DocumentCloses the active QlikView document.
ReloadPerforms a reload on the current document. This function does not work in AJAX client.
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.

View solution in original post

5 Replies
Gysbert_Wassenaar

Please read this document: QlikCommunity Tip: How to get answers to your post?

Have you tried searching this site?

https://community.qlik.com/search.jspa?q=action+trigger


talk is cheap, supply exceeds demand
mohammadkhatimi
Partner
Partner

Actions

On this page actions can be set for certain objects:

  • buttons
  • text objects
  • gauges
  • line/arrow objects

Actions include launching an external application or exporting data from QlikView.

   

AddOpens the Add Action Dialog where the actions for the object are chosen. Choose the type of action in the lists. Depending on the action, different parameters for the action will appear on the Actions page. The actions will be executed in the order in which they appear in the list.
DeleteRemoves the action from the object.
PromoteMoves the selected action up in the list of actions.
Alternate StateSets the state that the action refers to. This setting is only relevant for actions related to selections or bookmarks

Add Action Dialog

The following actions can be added from the Add Action dialog. In all fields with the ... button it is possible to enter a calculated formula, see Calculated Formula.

Selection

   

Select in FieldSelects 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 ExcludedSelects the excluded values in the specified field.
Select PossibleSelects 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.
ForwardGoes one step forward in the list of selections.
BackGoes back one step in the list of selections.
Pareto SelectMakes 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 FieldLocks the selections in the specified field.
Lock AllLocks all values in all fields.
Unlock FieldUnlocks the selections in the specified field.
Unlock AllUnlocks all values in all fields.
Unlock and Clear AllUnlocks all values and clears all selections in all fields.
Clear Other FieldsClears all related fields except the one specified.
Clear AllClears all selections except locked ones.
Clear FieldClears a specific field.
Copy State ContentsCopies the selection from the Source State to the Target State. Only available when alternate states have been defined.
Swap State ContentsSwaps the selections between State 1 and State 2. Only available when alternate states have been defined.

Layout

   

Activate ObjectActivates the object specified by Object ID. This function does not work in Ajax client.
Activate SheetActivates the sheet specified by Sheet ID.
Activate Next SheetOpens the next sheet in the document.
Activate Previous SheetOpens the previous sheet in the document.
Minimize ObjectMinimizes the object specified by Object ID.
Maximize ObjectMaximizes the object specified by Object ID.
Restore ObjectRestores the object specified by Object ID.
Set State NameApplies the specified State to the object specified by Object ID. Only available when having defined alternate states.

Bookmark

   

Apply BookmarkApplies 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 BookmarkCreates a bookmark from the current selection. Specify Bookmark ID and Bookmark Name. Select Hidden to create a hidden bookmark.
Replace BookmarkReplaces the bookmark specified by Bookmark ID with the current selection.

Print

   

Print ObjectPrints 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 SheetPrints the sheet specified by Sheet ID. (Not available as document and sheet trigger.) This function does not work in AJAX client.
Print ReportPrints 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

   

ExportExports 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)
LaunchLaunches 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 URLOpens 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 when using the Internet Explorer plugin

Run MacroEnter 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 VariableAssigns a value to the specified variable.
Show InformationShows 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 DocumentCloses the active QlikView document.
ReloadPerforms a reload on the current document. This function does not work in AJAX client.
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.

View solution in original post

mohammadkhatimi
Partner
Partner

For trigger examples check attachment

Regards

Mohammad

jagan
MVP
MVP

Hi,

Refer qlikview help file for detailed help on this, there are lot of types of triggers are available.

Regards,

Jagan.

Chanty4u
MVP
MVP
Author

thnk u so much jagan