Skip to main content

Official Support Articles

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!

How to run an automation once a month

cancel
Showing results for 
Search instead for 
Did you mean: 
Emile_Koslowski
Support
Support

How to run an automation once a month

 It is not possible to schedule an automation to run once a month through the Scheduled run mode alone. This article explains how this can be achieved by leveraging the Date formulas.

Environment

  • Qlik Sense Enterprise SaaS
  • Qlik Application Automation

Steps

  1. Create new automation and set the run mode to Scheduled and configure it to schedule every day.
    Emile_Koslowski_0-1641817190126.png

     

  2. Add a Condition block to the Start block. Click the Condition block's input field to configure the first argument of the Condition block. Select 'Add formula' and search for the Date formula in the Formula picker that pops up. Configure the Date formula as follows:
    Emile_Koslowski_0-1641819664373.png

     

  3. Now select "equals" as the condition block's operator and specify "1" as the second argument.

  4. Now place your automation in the YES output of the condition block. This will only be executed on the first day of every month.
    Emile_Koslowski_1-1641819762397.png

     

Bonus

  1. Instead of executing the whole automation in the YES output of the Condition block, execute a Stop block in the NO output of the block. Place your automation after the Condition block.
    Emile_Koslowski_2-1641819801954.png

     

  2. Execute an Update Job Title block when it's the first day of the month. This will make it easy to search for only relevant automation runs in the automation's history.
    Emile_Koslowski_0-1641818648417.png

     

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

Labels (2)
Comments
Hilda
Contributor
Contributor

Hi @Emile_Koslowski ,

At 1:00 am GMT+2 or Johannesburg South Africa time, my condition returned False. The user's profile in in the correct time zone.

Is there a way around this, similar to ConvertToLocalTime?

Your assistance will be appreciated.

Kind regards,

 

Emile_Koslowski
Support
Support

Hi @Hilda ,

Can you try to convert the timezone with the "Convert timezone" formula?

You'll find it in the formula picker :

Emile_Koslowski_0-1657030617897.png

Kind regards,
Emile

Hilda
Contributor
Contributor

Thanks @Emile_Koslowski , sorted.

prisma_dako
Partner - Contributor
Partner - Contributor

Hi @Emile_Koslowski , 

is it also possible to run an automation only at business hours? e.g. daily, but only from 08:00 to 18:00? I would like to save a few runs and I haven't discovered this function yet.

Kind regards, 

Daniel

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @prisma_dako

Is this the information you are looking for? Working with automation scheduling

If not, let me know and I can connect with a subject matter expert.

All the best,
Sonja

prisma_dako
Partner - Contributor
Partner - Contributor

Hello @Sonja_Bauernfeind 

Thank you for your feedback, unfortunately the problem is, I only want the automation to run in a period from 12:00 to 14:00, every 15 min, daily.

With the configuration below, the automation will run around the clock, every 15 mins.

prisma_dako_0-1671026174294.png

prisma_dako_1-1671026209996.png

Is it possible to run the automation in a certain period of time?

Monday: 12:00 to 14:00 every 15min
Tuesday: 12:00 to 14:00 every 15min
.
.
.
and so on.. (Daily)

Regards,

Daniel

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @prisma_dako 

I understand the query better now, thank you, and I can confirm that this is currently not possible out of the box. We have an active idea (which is marked to be on the roadmap) and I would suggest leaving your notes on it and voting for it! Automation schedule 

In addition, I've been given a possible workaround for you, which allows you to update the automation's schedule from within the automation: Qlik Application Automation: How to use the create and update automation blocks, and change automati... 

All the best,
Sonja

Version history
Last update:
‎2022-05-10 01:34 PM
Updated by: