Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
therealdees
Creator III
Creator III

How to create a check date/hour condition in Qlik Automation?

Hi

I'm trying to automate some stuff, but I'm not sure how I could reference the day and time in Qlik Automation condition block. Could anyone help me out?

 

Basically, as the scheduling options are kinda limited in terms of options, I thought maybe I could schedule the app to run every hour and then check if the current time is "x", if so, the routine will continue, else it'll just stop.

Does that make sense? Has anyone used it like this before?

Labels (3)
1 Solution

Accepted Solutions
therealdees
Creator III
Creator III
Author

Actually I managed to do it with the following format, for those who interest:

therealdees_0-1700166228857.png

 

and

 

therealdees_1-1700166263467.png

 

Note that the hour in the first image was manually input, but you could use something else.

 

The way it is, if I compare both dates I get the expected output (e.g if now > 17:15:00, then print 'True', 'False')

 

 

View solution in original post

3 Replies
therealdees
Creator III
Creator III
Author

Actually I managed to do it with the following format, for those who interest:

therealdees_0-1700166228857.png

 

and

 

therealdees_1-1700166263467.png

 

Note that the hour in the first image was manually input, but you could use something else.

 

The way it is, if I compare both dates I get the expected output (e.g if now > 17:15:00, then print 'True', 'False')

 

 

MikkoL
Contributor II
Contributor II

Any way to limit the actual automation start trigger not to run between like 10 am and 6pm?

Just because there are limits on how many automations are allowed in license. Automation still triggers tho the condition afterwards is correct. Mainly problem when you may have cases when automation is required to run for example 15 min repeat but only in certain times. 

blaise
Partner - Specialist
Partner - Specialist

I recommend using a 2nd automation that enable / disable the 1st automation at given times. You will consume 2 runs each day for this but its better than running an automation every 15 min if you don't need it for an 8 hour window.