2 Replies Latest reply: Jul 7, 2017 6:33 AM by Andy Weir RSS

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

    Apurva Vyas

      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?

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

          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

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

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

             

            sounds like you are reinventing the wheel.