Qlik Automate: How to run an automation between working hours and only on business days

Emile_Koslowski · Jan 21, 2025 7:12:07 AM

This article documents how to schedule automations between specific hours and days of the week. This is intended as a workaround until a native solution is delivered.

Getting started

Download the attached automation file (Automation on business hours and working days only.json) and import it into a blank automation workspace. See How to import and export automations.
Configure the timezone in the first variable block.
Update the first condition block to set the latest time (hour) and day of the week for which you want the automation to run. Define the hour in the 24-hour format and the day in a 1 (Monday) to 7 (Sunday) format.

For example, 5 pm on a Friday would be 17 (hour) and 5 (day).
Configure the Schedule Start and Time Interval parameters on the first Update Automation Schedule block. For Schedule Start you should only edit the time parameter, no changes are required to the date formula.
Update the second condition block to set the earliest and latest time (hour) at which you want the automation to run on business days.

Define the hour in the 24-hour format.

For example, 5 pm would be 17.
Now configure the other Update Automation Schedule blocks similarly to step 4, but do not edit the Schedule Start parameter on the middle Update Automation Schedule block as this will follow the automation's scheduled interval.

The information in this article is provided as-is and will be used at your discretion. Depending on the tool(s) used, customization(s), and/or other factors, ongoing support on the solution below may not be provided by Qlik Support.