Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have one doubt community,,,,that is difference between action and alert? with formal defination anybody help me? thanks in advance
Action :
Action can be attached to the following objects:
Buttons , Text Objects , Gauges and line/Arrow objects
To perform the action we have to do certain operation on a sheet or object.
For example using action we can activate particular chat or sheet.
Alert :
we use alert to pop up when certain threshold is exceeded.
Alert can be triggered by three events, after the document is opened, After reloaded and or after data reduction.
Alert pop a message, if needed we can setup email message too.
Hope this will help you.
Hi Pratap,
Action is a kind of Triggers, like OnActivateSheet, OnSheetLeave, OnOpen, OnAnySelect, Clear All, Clear Field, Select Field etc.
Refer below are actions avail available in Qlikview.(From Qlikview Help file)
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. |
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. |
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 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.) |
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.) 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:
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. |
Alert: Alerts can triggered when certain conditions met, support Sales of a month less than some value etc. Please check below
The easiest way to define an alert is by using the Alert Wizard that can be invoked from the Tools menu.
The Alerts dialog is opened from the Tools menu. This dialog is used for managing alerts, which are stored as part of the QlikView document. Alerts can be triggered from any Windows version of QlikView (that is, not from AJAX clients).
An alert is a composite entity typically consisting of three basic parts:
When an alert is checked and the condition is met and the action(s) performed, it can be said that to have fired. QlikView alert checks can be triggered in three different ways:
Use caution when creating alerts, large amounts of macro-triggered alerts can make the document sluggish!
The top left part of the dialog contains a list of alerts where all alerts currently defined in the document are displayed. The list includes three columns: ID, Enable and Description.
ID | The unique ID of the alert is displayed in the ID edit box as well as in the list of alerts. Upon creation, every QlikView layout entity, including alerts, is assigned a unique ID for control via Internal Macro Interpreter. The first alert of a document will be assigned the ID AL01. It is possible to edit this ID number later on in the ID edit box. |
Enable | Select or deselect the check box in order to enable/disable the alert. |
Description | Description of an alert as defined under Description (see below). |
Add | The Add button adds a new default alert to the list for further editing. |
Remove | Selecting an alert and clicking the Remove button deletes it from the list. |
Condition | The Condition group is used for defining the conditional expression. (Condition) This is a QlikView expression that should evaluate to true (non zero) when the alert is to fire. All Clear If this option is checked the all clear state will be used when evaluating the alert condition. Bookmark If All Clear is left unchecked, you may specify a bookmark to be applied before the alert condition is tested. The bookmark should be stated as a bookmark ID. The bookmark must exist for the alert to work properly. If no bookmark is specified and the All Clear check box is left unchecked, the current selections (i.e. the logical state of the document) will be used when the alert condition is tested. |
Events | The Events group is used for defining automatic event checks. On Open The alert is automatically checked when the document is opened. On Post Reload The alert is automatically checked after a script execution (Reload) of the document. In addition, the alert is also checked upon opening of the document, provided that the last reload time stamp stored in the document is later than the time stamp noted when the alert was last checked. On Post Reduce The alert is automatically checked after a data reduction (Reduce Data command) of the document. In addition, the alert is also checked upon opening of the document, provided that the last reduction time stamp stored in the document is later than the time stamp noted when the alert was last checked. Delay The re-firing of automatically checked alerts may be suspended for a given number of Days after an alert has been fired. Decimals may be used for specifying fractions of a day. The value 0 of course indicates that no delay will be applied. Trigger Level The re-firing of automatically checked alerts may also be suspended on the basis of whether the alert status has changed after the firing. In the drop-down list you can choose between three levels of reoccurrence: Always means that the alert is fired every time the trigger event(s) occur and the alert condition is fulfilled. Message Changes means that the firing of the alert is suspended until the alert Message changes. This is of course only meaningful with dynamic message text. (Note that the state of the alert condition does not necessarily have to change in order for the evaluated message to change. Any change in the Mail Subject line (see below) will be regarded as change of message.) State Changes means that the firing of the alert is suspended until the alert state changes, i.e. the alert condition was unfulfilled during at least one check and then becomes fulfilled again during a later check. This is the strongest type of alert suspension. |
Show Popup | Mark the check box Show Pop-up to show the alert message as a pop-up balloon when the alert is fired. |
Use Custom Popup | The Use Custom Pop-up group lets you define a custom pop-up format for the selected alert. By checking this alternative, you can replace the default Alert Pop-up Settings as defined in Document Properties: General. The Pop-up Settings button opens the Pop-Up Window Settings dialog. |
Mode | In the Mode group you can check the relevant options in order to define an alert as an Interactive (automatic triggers in layout) and/or as an alert relevant for external programs running QlikView in Batch mode (command line execution), e.g. QlikView Publisher, via the special Automation API for Batch triggers. If none of the check boxes in this group are marked, the alert can still be manually checked via macros. |
Description | A commentary field where the creator of an alert can describe the purpose of an alert. It is only used in the list of alerts in this dialog. |
Message | The Message edit box is where you type the message to be displayed with the alert. For pop-up alerts the text will appear in the pop-up, for e-mail alerts this is the body text of the e-mail. The message text may be defined as a Calculated Formula for dynamic update. Click the ... button to open the Edit Expression dialog for easier editing of long formulas. |
Mail Subject | In the Mail Subject edit box a text to be used for the subject line in e-mail alert messages can be entered. The text may be defined as a calculated label expression for dynamic update. Click the ... button to open the Edit Expression dialog for easier editing of long formulas. If left empty, the subject line will display the text 'QlikView Alert'. |
Mail Recipients | The Mail Recipients pane is a semi-colon separated list of mail addresses. Each addressee will receive an e-mail message whenever the alert fires. The list may be defined as a calculated string expression for dynamic update. |
Hi,
Action is nothing but work that has to do. Alert is a message that has to be displayed after an action or a trigger or on a particular criteria.
See the attachment for QV Alerts.