topic Last reload end time in QlikView

Last reload end time

alkesh_sharma — Fri, 27 Jun 2014 05:25:55 GMT

Hello,

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

Thanx in advance.

Re: Last reload end time

its_anandrjs — Fri, 27 Jun 2014 05:29:33 GMT

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

Re: Last reload end time

aveeeeeee7en — Fri, 27 Jun 2014 05:32:43 GMT

See this Post:

http://community.qlik.com/thread/18158

Re: Last reload end time

amit_saini — Fri, 27 Jun 2014 05:32:48 GMT

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,

Re: Last reload end time

Anonymous — Fri, 27 Jun 2014 05:33:05 GMT

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

Re: Last reload end time

SunilChauhan — Fri, 27 Jun 2014 05:33:45 GMT

you can fetch this from log file

last line datetime. try your trick to find it our

Re: Last reload end time

Fri, 27 Jun 2014 05:36:49 GMT

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

Re: Last reload end time

Anonymous — Fri, 27 Jun 2014 09:49:06 GMT

Hi..

Use let vreloadtime=now(0)

This gives you the time when the reload ended.

HTH

Ravi N.

Re: Last reload end time

Anonymous — Fri, 27 Jun 2014 10:03:42 GMT

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