Qlik Automation - Inconsistent Variable Value

[FrankRook]

Hello,

I have an app that reloads every hour, and after it reloads it sends an email showing the status of various data pipelines.

I've created a couple of variables that store the latest timestamp and hour that data entered the app.

vLatestData, and vLatestDataHour and for the most part it works, below are both variables working as intended.

The automation runs after reload is successful and checks the vLatestDataHour variable and uses it in the email body, along with a screenshot of the sheet (In the screenshot, you can see the vLatestData variable at the bottom left of the sheet.

The problem is they don't match when the email is sent, however as soon as i open the app they're matching like what I shared above.

Is it a cache thing? do I need to add an extra step at the beginning of the automation to save the app before proceeding?

Thanks alot

[marksouzacosta]

Hi @FrankRook ,

A few questions:

1. "The automation runs after reload is successful". How are you chaining this process? We need to know this in detail.
2. What is the definition of both of your variables?

Regards,

Mark Costa

[FrankRook · Accepted solution]

Thanks for the reply, Mark. I added a sleep block with a 30 second timer, that gave the variables time to change after the reload and it fixed the issue.