Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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

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?

1 Solution

Accepted Solutions
ahaahaaha
Honored Contributor

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

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

1.jpg

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

2 Replies
ahaahaaha
Honored Contributor

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

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

1.jpg

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
Honored Contributor II

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

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

sounds like you are reinventing the wheel.