Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
rahulsud007
Creator
Creator

List of all reload.

Dear experts, Can u please let me know if there is any particular script which will help me in getting my list of reload. time, as shown in the image

7 Replies
buzzy996
Master II
Master II

see tis,

time.PNG

rahulsud007
Creator
Creator
Author

Hi Shiva, its not possible. I have tried reloadtime() as reload, but it gives me only the timing of last reload.

While I need a list last 3 reloads.

ramoncova06
Specialist III
Specialist III

you will have to create a qvd that stores you loading times, and then read from it

rahulsud007
Creator
Creator
Author

Hi Ramon, can u give me a small example or a qvw?

ramoncova06
Specialist III
Specialist III

here is something you could use , just ensure that you use the correct paths for the "filtime", "store" and "from"

  if isnull(filetime( 'LoadTime.qvd' ))  then

  LoadTime:

  load

  now() as LoadTime

  AutoGenerate(1);

  Store LoadTime into LoadTime.qvd(qvd);

ELSE

  LoadTime:

  load

  now() as LoadTime

  AutoGenerate(1);

  Concatenate(LoadTime)

  load

  LoadTime

  from LoadTime.qvd(qvd);

ENDIF;

rahulsud007
Creator
Creator
Author

Thanks Ramon. Your answer was helpful. I needed to create a qvd where I included a field as reloadtime() as reload.

And called that qvd.

ramoncova06
Specialist III
Specialist III

just replace now() with reloadtime()