Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

alkesh_sharma
Contributor III

Last reload end time

Hello,

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

Thanx in advance. 

8 Replies

Re: Last reload end time

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
Valued Contributor III

Re: Last reload end time

amit_saini
Honored Contributor III

Re: Last reload end time

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

nishaloganathan
Contributor II

Re: Last reload end time

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
Esteemed Contributor

Re: Last reload end time

you can fetch this from log file

last line datetime. try your trick to find it our

Not applicable

Re: Last reload end time

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

ravic906
Contributor III

Re: Last reload end time

Hi..

Use let vreloadtime=now(0)

This gives you the time when the reload ended.

HTH

Ravi N.

satyadev_j
Valued Contributor

Re: Last reload end time

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