Button + Reload Data or Button + Execute App Automation - which do I use?

[Michael_Tarallo]

Learn the differences between Qlik Sense button actions - Reload Data and Execute Automation - when you want to reload a Qlik Sense app, or have ANY user execute an automation.

[Michael_Tarallo]

When creating Qlik Sense Apps  - you can use a Button object and configure a variety of actions or navigation settings to it. One of those actions is the ability to Reload Data for the app you are in. This comes in handy during development, but also can be used where users require new data on demand.

However, when using the Reload Data action - other users may not be able to perform the reload action as they don't have ownership of the app or reload rights to the app / space the app is developed in. Here is an approach when using Qlik Cloud and Qlik Application Automation that can workaround that. This approach will also work for any App Automation that you want any user to execute. 

[nik0580]

Hi @Michael_Tarallo , thank you for the video. Could you may be in another video showcase how you configured form fill up kind objects and allowed user to input data ? Also in which table the data gets stored. Thank you.  

[nfiddaITM]

Hello @Michael_Tarallo , there is a limit of reload executions carried out by users in qlik Sense SaaS ?

[Michael_Tarallo]

Hi guys - yes Nik I can create another video on that topic and Nfiddal - there are capacity based operations for executing reloads and app automations, you would need to check with your Qlik partner or rep for more information on that. 

[reneviz1971]

Hello @Michael_Tarallo , is it possible to pass variables to the Qlik Sense app to the automation process?, that is, using the button to execute the automation the script I have made uses a couple of variables, How could I pass to  the automation uses them when executing the reload script?

[robert99]

Hi @Michael_Tarallo 

I assume the User must have a Professional License. Or can an Analyzer license holder reload using automations

Thanks

[mshann01]

Any ideas for preventing multiple users from triggering reloads simultaneously or even submitting a reload request while a scheduled one is running?  I was thinking of maybe controlling the button with a variable and then having the automation first set the variable to inactivate the button.  Not sure if the Save App block would push the variable update to all end users timely enough while the reload is running.  The reload time for this particular app is 2 min but some others could be much longer.

[Natalia_Kapelian]

Hi @mshann01, I have the same problem with preventing multiple users from triggering reloads simultaneously. Were you able to find some solution or workaround, could you share, please?

[mshann01]

@Natalia_Kapelian , my team and I actually implemented the solution across a few of our dashboards so far. 

• We created a variable in the app that enables/disables the reload button. 
  • When the variable = 'N', the button is greyed out and displays 'Data currently reloading'
  • When the variable = 'Y', the button is clickable and displays 'Reload Data'
• In the automation
  • we first update the variable value to 'N'
  • Save the app
  • Do reload
• In the app load script, set the variable to 'Y' to enable the button again

It's a bit of a pain to migrate from a shared space to a managed space because the app id changes and sometimes the variable id depending on how you implement it.  You have to go into the automation and make sure those are set correctly after migrating.  Otherwise, it seems to work well for our use cases.

[Natalia_Kapelian]

Thank you, @mshann01, for sharing the solution, it works perfectly fine.

[robert99]

Hi All

In the automation

• we first update the variable value to 'N'

Ive tried to do this but can't get it to work

Can anyone help. With the detailed steps required

Thanks Robert