Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Trigger in qliksense after db is refreshed

Hi All,

I want to reload my applications only after db tables are refreshed.

Is there any trigger where my code will check if db tables are refreshed then my qlik applications will run, if db tables are not refreshed then qlik application won't start.

Can anybody help to get this.


Thanks in advance!


Labels (2)
2 Replies

Can you query your DB for a date or some data point that tells you if it was refreshed? If so, add an IF statement at the beginning of your application -- if the query shows the DB was refreshed, THEN proceed to rest of script, ELSE exit the script.

Since you have multiple applications, it might be more efficient to do this in just one application and save the query result to a QVD, and use that in subsequent applications.



If your DB can run scripts you may want to look at Qlik Cli. Reload could be triggered from command like the one below: 

Start-QlikTask "Reload Operations Monitor" -wait | Wait-QlikExecution



cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.