Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to show last update moment in a text box

Hi,

I wonder if there is a way to show in a text box (for example) the moment the the script was lauched for the last time so the data updated.

Any idea please?

Thanks

1 Solution

Accepted Solutions

Re: How to show last update moment in a text box

Use this in text box...

='Last Updated '&Date(ReloadTime())&CHR(10)

&Hour(NOW()-ReloadTime())&' Hour(s),'&CHR(10)

&Minute(NOW()-ReloadTime())& ' Minute(s) and'&CHR(10)

&Second(NOW()-ReloadTime())& ' Second(s) ago' & CHR(10)&

'By '&Capitalize(Replace(SUBFIELD(OSUser(),'\',2),'.',' '))

10 Replies
ashwanin
Valued Contributor

Re: How to show last update moment in a text box

use

ReloadTime()  function

Re: How to show last update moment in a text box

Use ReloadTime() function

manojkulkarni
Valued Contributor II

Re: How to show last update moment in a text box

use qlikview function ReloadTime()

vipin_mishra479
Contributor II

Re: How to show last update moment in a text box

hi,

use reload time() function

Re: How to show last update moment in a text box

Use this in text box...

='Last Updated '&Date(ReloadTime())&CHR(10)

&Hour(NOW()-ReloadTime())&' Hour(s),'&CHR(10)

&Minute(NOW()-ReloadTime())& ' Minute(s) and'&CHR(10)

&Second(NOW()-ReloadTime())& ' Second(s) ago' & CHR(10)&

'By '&Capitalize(Replace(SUBFIELD(OSUser(),'\',2),'.',' '))

Not applicable

Re: How to show last update moment in a text box

Now(0) is also a possibility

Fabrice

amit_saini
Honored Contributor III

Re: How to show last update moment in a text box

Hi Luis,

Try this:

='[ Updated at

' & timestamp(reloadtime(), 'hh:mm on

MMM DD, YYYY') &' ]'

Not applicable

Re: How to show last update moment in a text box

Is there a way to get AM or PM on the timestamp?

amit_saini
Honored Contributor III

Re: How to show last update moment in a text box

Check this:

Suppose , 'T' in your timestamp format will be translated to either 'P' or 'A' as part of 'TT' resp. 'PM','AM'.

I think you can create your own format while keeping the numeric representation using dual() function:

[assuming a TimeStamp TS with a valid numeric representation]:

LOAD

     TS,

     dual( Date(TS,'YYYY-MM-DD') &'T' & time(TS,'hh:mm:ss'), num(TS) ) as MyTimeStamp,

Thanks,

AS

Community Browser