Question about Qlik Automation (not the app)

[jmurrevcyc]

Hello, to clarify before I start, I do not have the Qlik App Automation software in my tenant subscription. That said, I would like to know if Qlik App Automation can do this, or if it can be done without using it.

Scheduling and executing apps with variables outside of the loadscript editor.

QlikSense question:

Current State:

Currently I have a variable let statement in the load script. I change the dates when I want to run it.

Let vStart = '20220701'; // This parameter is used in psl, and patient collections queries
Let vEnd = '20221130'; // This parameter is used in psl, and patient collections queries

SQL

WHERE
TRANS.PostingDateID
between
$(vStart) and $(vEnd)

Those dates pass through the rest of the load scripts, so I only need to change it in one place. But that is still a manual process, since I have to go into the load script and change the dates.

I would like to know:

1. if there is a way to schedule my app to run at a certain day/time?

2. Is it possible to specify variables within the scheduler that can be passed to the load script at run time?

[jmurrevcyc]

QlikSense question:

Current State:

Currently I have a variable let statement in the load script. I change the dates when I want to run it.

Let vStart = '20220701'; // This parameter is used in psl, and patient collections queries
Let vEnd = '20221130'; // This parameter is used in psl, and patient collections queries

SQL

WHERE
TRANS.PostingDateID
between
$(vStart) and $(vEnd)

Those dates pass through the rest of the load scripts, so I only need to change it in one place. But that is still a manual process, since I have to go into the load script and change the dates.

I would like to know:

1. if there is a way to schedule my app to run at a certain day/time?

2. Is it possible to specify variables within the scheduler that can be passed to the load script at run time?

[J_Lindberg · Accepted solution]

Hello @jmurrevcyc ,

Qlik Application Automation is today only available in Qlik Sense Enterprise SaaS licenses. You should be able to enable automations in your tenant's management console. Please reach out to your account manager if you don't see automations in the management console.

When it comes to Qlik Application Automations it is possible to use variables to update the load script from within a scheduled automation that then reloads the application.

Information on enabling Automations for a tenant: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Admin/mc-managing-automa...

Information on Automation scheduling:
https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_QlikAutomation/working-with-...

Video showing how to create a load script in automations:
https://youtu.be/a0UrcSM1wL0?t=1267

Video showing how to work with reloads in automations:
https://youtu.be/JY1B5UrFKCk?t=326

Here you can find out how Application reloads can be scheduled using the Management Console: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Apps/reloading-apps-clou...

[jmurrevcyc]

@J_Lindberg , I have been doing some more thinking. One question I have is if I use the QMC to schedule a reload, would I pick partial reload so as to be able to specify script variables that can be passed at run time? Understanding that Qlik Automation App has a more robust way to handle this, could QMC be a viable alternative approach provided we probably aren't including the Qlik Automation App in our subscription? 

[J_Lindberg]

Hello @jmurrevcyc , I'm afraid that would not be possible.

You can access the scheduler by expanding "More actions":

This is what can be configured:

Regarding automations, a "Qlik Sense Enterprise SaaS license" has 5000 Automation runs included per default.  You might also be able to use variable values and pass them in the script using an API that support that. What do you want to achieve by setting these variables?

[jmurrevcyc]

Thank you,

Honestly my access is very limited in my current role, so I am unable to implement anything. I really wanted to understand for my own edification. I was thinking, if I could throw some type of conditional variable like:

if today >= the 15th of the month, set dates and date ranges to ...

load data with calculated variables, etc...

For me at least it would be nice to know that QlikSense can do that.