topic Re: the last date of loading data in QlikView

the last date of loading data

Mon, 04 Jan 2016 19:16:48 GMT

hi all,

can anyone please tell me how to get date of the last loading of values from database (the last update)

maxgro — Mon, 04 Jan 2016 19:35:53 GMT

if you mean the time of QlikView load you can use the function

ReloadTime( )

Returns a timestamp for when the script last finished reexecuting.

if you mean the last time a record in a db table was updated/inserted, you need an ad hoc field in the db table

EDIT:

In script, ReloadTime() returns the end time of the previous reload

For start time of the script you can use a variable at the beginning of the script

LET startofthescript = now(1); // 1 Time at function call

sunny_talwar — Mon, 04 Jan 2016 19:36:10 GMT

Create a variable at the end of your script:

vLastReload = Now();

now the next time you reload, vLastReload will be the timestamp of when your last reload finished.