RE:Actions&Triggers

Chanty4u — Wed, 20 May 2015 02:44:31 GMT

hi guys,

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

thnks.

Suresh

Re: RE:Actions&Triggers

Gysbert_Wassenaar — Wed, 20 May 2015 05:14:44 GMT

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

Re: RE:Actions&Triggers

mohammadkhatimi — Wed, 20 May 2015 05:20:02 GMT

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.

Add	Opens 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.
Delete	Removes the action from the object.
Promote	Moves the selected action up in the list of actions.
Alternate State	Sets 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 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.
Copy State Contents	Copies the selection from the Source State to the Target State. Only available when alternate states have been defined.
Swap State Contents	Swaps the selections between State 1 and State 2. Only available when alternate states have been defined.

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.
Set State Name	Applies the specified State to the object specified by Object ID. Only available when having defined alternate states.

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

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

Re: RE:Actions&Triggers

mohammadkhatimi — Wed, 20 May 2015 05:26:06 GMT

For trigger examples check attachment

Regards

Mohammad

Re: RE:Actions&Triggers

jagan — Wed, 20 May 2015 05:35:32 GMT

Hi,

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

Regards,

Jagan.

Re: RE:Actions&Triggers

Chanty4u — Wed, 20 May 2015 06:22:05 GMT

thnk u so much jagan

topic Re: RE:Actions&Triggers in QlikView

RE:Actions&Triggers

Re: RE:Actions&Triggers

Re: RE:Actions&Triggers

Actions

Add Action Dialog

Selection

Layout

Bookmark

Print

External

Re: RE:Actions&Triggers

Re: RE:Actions&Triggers

Re: RE:Actions&Triggers