Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
alkesh_sharma
Creator III
Creator III

Last reload end time

Hello,

I need last reload end time as reloadtime() gives melast reload start time.

Thanx in advance. 

8 Replies
its_anandrjs

Use Now() or Reloadtime() function but better you use NOW() with variables

See simple way

Let vStart = NOW();

Load statements

..

..

Let vEnd = NOW();

Let Totaltime  = Time(vEnd-vStart); //For total time duration you can use this line

aveeeeeee7en
Specialist III
Specialist III

amit_saini
Master III
Master III

Alkesh ,

Could you please elaborate what exactly you are looking for. If you want to see last reload time than use this script below:

='[ Updated at ' & timestamp(reloadtime(), 'hh:mm on MMM DD, YYYY') &' ]'

Thanks,

AS

Anonymous
Not applicable

Hi,

You can give like,

before start the script

Let vStart = now()

At the end of the script

Let vEnd = now()

Then Using vStart variable, you can get start reload time

Using vEnd variable , You can get end reload time.

If you want to calculate reload maximum time, you can use below expression

=time(vStart - vEnd, 'hh:mm:ss')

Hope it may helps

SunilChauhan
Champion
Champion

you can fetch this from log file

last line datetime. try your trick to find it our

Sunil Chauhan
Not applicable

Hi,

Use Now() at the of the script

so when u will reload the script it will be the last statement to be executed , and that time will be your reload end time.


Regards,

Vivek

Anonymous
Not applicable

Hi..

Use let vreloadtime=now(0)

This gives you the time when the reload ended.

HTH

Ravi N.

Anonymous
Not applicable

Not sure if I understand correctly but reloadtime() function always shows the application loading finish time.