topic Last ReloadTime() in QlikView

Last ReloadTime()

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a RecordCreatedDate column in which record date along with time is stored.

How can I use the ReloadTime() in script so that I can load the data (RecordCreatedDate) which is greater than than previous ReloadTime.

Also, is there any temporary storage to store any value, such as ReloadTime() so that in can be used in next reload.

MK9885 — Tue, 19 Dec 2017 19:33:32 GMT

Maybe the below script?

Refreshtime:

load

QvdCreateTime('C:\YOURDESTINATIONFORQVD\ABC.QVD') AS QVDTIME

AutoGenerate 1;

Load

Date(QVDTIME, 'MM/DD/YYYY hh:mm:ff TT') as QVDDate

Resident Refreshtime;

There can be more to it depending what you want....but this will only tell when the QVD was created

ravikumar_iyana — Wed, 20 Dec 2017 02:59:57 GMT

Hi Amar,

You can use like this " =' Last Refreshed Date: '&Date(ModifiedDate, requireddateformat) "

vishsaggi — Wed, 20 Dec 2017 03:19:41 GMT

May be use a variable to store your refresh time like

LET vReloadTime = ReloadTime();

LET vReloadTime = Date(ReloadTime());