topic Re: update date and time from a button in QlikView

update date and time from a button

Anonymous — Thu, 13 Nov 2014 15:47:39 GMT

Upon pressing the button I want that updates the date and time.

The only way that is updated by a partial reload of data.

in my textbox I have ='Última Actualización ' & timestamp(reloadtime())

what I want is to press the button and my box is upgraded

thanks for the support!!

ali_hijazi — Thu, 13 Nov 2014 15:53:30 GMT

Actually reloadtime() will give you the last time the document was reloaded

this will be updated after each reload and end users will see the correct and updated time

unless you want an updated time of actual date then you can use Now() in your text object

Anonymous — Thu, 13 Nov 2014 16:02:22 GMT

what I mean is that when I select the blue button to save the date and time at which the button was pressed and the info that I keep a QVD.

thanks for the support

ali_hijazi — Thu, 13 Nov 2014 16:10:13 GMT

ok but keep in mind end users who see the document via browser cannot reload the document

this can be done only via the client

ok in your script at the final end line put the following script:

let vReloadTime = TimeStamp(Today());

Reload_Time:

load $(vReloadTime) as Reload_Time

autogenerate 1;

store Reload_Time into Reload_Time.qvd

let vReloadTime = null();

drop table Reload_Time;

hope this helps!!

MarcoWedel — Thu, 13 Nov 2014 22:52:45 GMT

Hi,

maybe like this:

hope this helps

regards

Marco