Skip to main content

Tutorial - Alerts

You can monitor critical data without opening your Qlik Sense apps. SaaS editions of Qlik Sense lets users set conditions based on measures or dimensions, and receive alerts when they are met. Alerts can be evaluated each time the app is reloaded or based on a schedule. You can share alerts with any user that has read permissions for the app.

What you will learn

This step-by-step guide will show you how to:

  1. Create a simple alert.

  2. Create a complex alert.

  3. Manage an alert's life cycle.

Who should complete this tutorial

This tutorial is for users who are comfortable working in the Qlik Sense hub.

Note: If alerts are not working, contact a Qlik Sense administrator. They might need to turn on alerts.

What you need to do before you start

Download tutorial app and data

Download the CreatingAlertsFiles.zip file. It contains the app and data files needed to complete this tutorial:

Creating alerts files

Upload the tutorial app

You need to unzip the folder and upload the app and data files to a space in Qlik Sense. The app is similar to the app from Tutorial - Beginning with the Basics, except a script was added to keep the dates current.

  1. Unzip the CreatingAlertsFiles file.

  2. Open the Qlik Sense hub.

  3. Open a space, such as Personal.

    You can pick a different space if you want other users to be able to access this app and data files.

  4. Click Add new > Upload app. A dialog box opens.

  5. Drag and drop the Creating alerts.qvf file. Click Upload.

  6. Click Add new > Data file. A dialog box opens.

  7. Drag and drop the five Microsoft Excel files onto the dialogue box. Click Upload.

Create dynamic bookmarks

Qlik Sense apps often include data over multiple years. Alerts are usually set for the current time period (current week, month, or quarter). To imitate a realistic scenario, you need to create dynamic bookmarks.

  1. Open the app and open any sheet.
  2. Click Selections tool .
  3. The selections screen will appear. The App dimensions are at the bottom of the screen. Make sure that the Show fields check box is selected.
  4. In the search box on the right-hand side, type YearMonth.
  5. Find the Date.autoCalendar.YearMonth dimension and click .
  6. In the search list box, type the following function =Date.autoCalendar.YearMonth=Monthstart(Now()). Press Enter. The current month is selected.
  7. Close the selections tool by clicking Selections tool.
  8. Click Bookmark Bookmark .
  9. Click Create a new bookmark. Under Title, type Current month.

Using the same procedure, create the following bookmarks. Ensure you clear the previous selections before you make new ones:

  • Last Month: =Date.autoCalendar.YearMonth=Monthstart(Now(),-1)
  • Current Quarter: =Date.autoCalendar.YearMonth>=Quarterstart(Now(),-1) and Date.autoCalendar.YearMonth<Quarterstart(Now())
  • Last Quarter: =Date.autoCalendar.YearMonth>=Quarterstart(Now(),-2) and Date.autoCalendar.YearMonth<Quarterstart(Now(),-1)

Enabling notifications

You can customize notifications in your Qlik Sense hub.

  1. Open the hub, and open Profile settings.

  2. Click on Notifications.

  3. Under Alerts, you can choose to receive alerts via Web, Push, or Email.

For more information, see Managing your alerts

Creating a simple alert

You will create an alert that monitors the profit margin rate and sends a notification when it becomes less than 40 percent.

Creating a new alert

  1. Open the app. Open the Dashboard sheet in Analyze view.

  2. Right-click the Profit Margin gauge in the top-right corner.

  3. From the menu, select Create alert.

    A dialog box opens.

    Context menu showing sheet options

  4. In the detail section, insert:
    1. Title: Profit Margin Rate
    2. Description: Profit Margin should never fall below 40%
  5. In the Add data to the alert section, click the Add measure. Under Master measures, select: Margin %.
  6. Click on Refine your data. From the Selections dropdown, select Current Month as the bookmark to apply to the data.

    Data preview shows the current measure value, taking into account the bookmark applied.

  7. Click Next.
  8. Under Condition 1, set the following:
    1. Measure: Margin %
    2. Operator: Less than
    3. Compare with: Value

    4. Value: 0.4

      ALerts window showing the condition

  9. Click Next.

    This dialogue box shows alert scheduling. Keep the default settings.

  10. Click Create.

Testing the alert

This alert evaluates when the app is reloaded.

  1. From the hub, click on your user button in the top-right corner.
  2. Click Profile settings.
  3. Under Management, click Alerts.
  4. Find the Profit Margin Rate alert you created and click More. Click Details.
  5. Notice that this alert has never been evaluated. This is because the profit margins have not changed. We need to change the data to trigger the alert.
  6. From the context menu, click Edit alert in app. The Alert dialog box will open.
  7. Raise the Margin value to 0.43 (or higher than the actual value).

  8. Go back to the hub. Find the app and click More. From the context menu, click Reload.

You will see a notification on the top menu. Click the alert. A dialog box opens showing that profit margins have fallen below 40 percent.

Your email may also contain an from Qlik Sense, depending on your notification settings.

Creating a complex alert

We will create a monthly alert that monitors the last quartile product type margin rate in a specific sales range.

Creating a new alert

  1. Open the app in Qlik Sense. Open the Customer Details sheet in Analyze view.
  2. Find the pivot table labeled "Customer KPIs" at the bottom of the page. Right-click it.

  3. From the context menu, select Create alert > Create new alert.

    A dialog box opens.

  4. In the detail section, insert:
    1. Title: Low margin products last month
    2. Description: Monthly products that need margin improvements
  5. In the Add data to the alert section, click on Add measure and select:
    1. Sales
    2. Margin %
  6. Click on Refine your data. Select:
    1. Show by dimension: Product type

    2. Selections: Last Month as the bookmark to apply to the data.
  7. Data preview shows the product type by sales and margin percent, taking into account the bookmark applied.
  8. Click Next.
  9. Under Condition 1 set:

    1. Measure or dimension: Sales
    2. Operator: Greater than
    3. Compare with: Value
    4. Value: 50000
  10. Click Add additional condition
  11. Under Condition 2 set:
    1. Measure or dimension: Sales
    2. Operator: Less than
    3. Compare with: Value
    4. Value: 100000
    5. Ensure that there is an And operator between the two conditions.

      AND operator between Condition 1 and Condition 2

  12. Click Add additional condition.
  13. Under Condition 3 set:
    1. Measure or dimension: Margin %
    2. Operator: Less than
    3. Compare with: Current set
    4. Aggregation: Percentile
    5. Percentile: 25 (this means the last quartile)

      Dialogue window showing all three conditions that were made

    6. Click the linked between Condition 2 and Condition 3 to ungroup them. Ensure that there is a Then operator between the last two conditions.

      THEN operator between Condition 1 and Condition 2

  14. Preview alert might be blank. If this is the case, increase the percentile value.

  15. Click Next.
  16. Set Evaluate this alert to Monthly.

  17. Click Create.

Testing the alert

This alert is set to evaluate once a month. However, if you own an alert, you can evaluate it at any time.

  1. From the hub, click on your user icon in the top-right corner.
  2. Click Profile settings.
  3. Under Management, click on Alerts.
  4. Find the Low margin products last month alert and click More.
  5. From the context menu, click Evaluate Now.

You will see a notification on the top menu.

Alert life cycle

This section explains how to manage alerts after they are created.

Turn alerts on and off

Alerts are created based on visualizations, but they are not linked to them. Deleting charts does not delete associated alerts. Only administrators and alert owners can turn alerts on and off.

Manage alerts as owner

  1. From the hub, click on your user icon in the top-right corner.
  2. Click Profile settings.
  3. Under Management, click on Alerts.
  4. For each alert, the More opens the context menu. From here you can disable and delete alerts.

Viewing alert details

You can check alert details, conditions, and execution history.

  1. From the hub, click on your profile button in the top-right corner.
  2. Click Profile settings.
  3. Under Management, click Alerts.
  4. Find the Low margin products last month alert.
  5. Click More.
  6. From the context menu, click Details.
  7. The left-hand side menu shows: Details, Data & Conditions, History, Recipients, and Notifications.

    These sections cannot be edited.

  8. From the Details section, click View to display the most recent alert.

Modifying an alert

  1. From the hub, click on your profile button in the top-right corner.
  2. Click Profile settings.
  3. Under Management, click Alerts.
  4. Find the Low margin products last month alert.
  5. Click More.
  6. From the context menu, click on Edit alert in app. The Alert dialog box will open.
  7. Leave Details & data section as is. Click Next .
  8. Leave the Conditions section as is. Click Next.
  9. In the Distribution section, change Allow notifications and set Always.
  10. Click Save.