How to capture load time of an app in Qlik Sense?

[#1]

Hi all,

Some of my apps on Qlik Sense enterprise are scheduled to run every morning and I am trying to make a monitoring dashboard for those apps. So for that I need to capture the load time of those apps and compare with today's date, if that matches then flag should be green otherwise red. Can anyone help me with this?

[ahaahaaha · Accepted solution]

Hi,

As variant.

Suppose you have three working bases Qlik Sense and you want to track the timeliness of the download. At the end of the script code in each QS, insert the following code snippet in addition (marked in red).

TableData:  // script code

Load

RecNo() as ID

AutoGenerate 10;

TableReload: // new script code

Load

ReloadTime() as ReloadTime

AutoGenerate 1;

Store TableReload into 'lib://App/myfile1.qvd';

This code fragment along the specified path will create file QVD containing the time of the penultimate load. For each database, a file with its unique name will be created, in this case myfile1, myfile2, myfile3.

Next, you create a new application Qlik Sense for monitoring with the following script code

FOR i=1 To 3

LOAD

    'Base'&$(i) as Base1,

    FileTime() as ReloadTime1

FROM [lib://App/myfile$(i).qvd]

(qvd);

NEXT

and create  UI table with expression for calculation

If(Date(Today())> Date(ReloadTime1),'!', ' ')

and  background color expression

If(Date(Today())> Date(ReloadTime1),Red(), Green())

Result

Actually, that's all. In conclusion, it should be noted.

For load into the control application Qlik Sense, we used the attribute "time of the last modification" of QVD files of each database. In the QVD files, field [ReloadTime] contains information about the time of the penultimate load. To use it in the script, you can include the following code snippet.

FOR i=1 To 3

LOAD

    'Base'&$(i) as Base1,

    "ReloadTime" as ReloadTime1

FROM [lib://App/myfile$(i).qvd]

(qvd);

NEXT

In attached file example app Qlik Sense for control.

Regsrds,

Andrey

[ogster1974]

Surely you can use the task details section of the in built monitoring app to track this?

sounds like you are reinventing the wheel.