Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
Surely you can use the task details section of the in built monitoring app to track this?
sounds like you are reinventing the wheel.