Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
agni_gold
Specialist III
Specialist III

How to show last reload time of QV document into another QV document

How can i show the last reloaded time of a QV document into another QV document , without using log file .

8 Replies
Not applicable

try like

reloadltime(applicationname);

vinay_hg
Creator III
Creator III

reloadtime(appname)

or

if u r loading that app1 as binary load into ur app2 then

reloadtime() as reload time, in app1 script use this filed in app2

agni_gold
Specialist III
Specialist III
Author

Sorry vinay this is not working

mangalsk
Creator III
Creator III

Hello,

Create variable in your application as

let qvRefresh=QvdCreateTime('..\qvd_name.qvd');

and now you can show value of qvRefresh

amit_saini
Master III
Master III

Agnivesh,

In your first QVW use this as suggested my Manish:

How to calculate total reload processing time in qlikview

Later use binary load and call this expression in text box.

Thanks,

AS

jagan
Partner - Champion III
Partner - Champion III

Hi,

Try like this

in the first QVW create an additional table like this at the end

ReloadTime:

LOAD

Now() AS LastReloadTime

AUTOGENERATE 1;

STORE ReloadTime INTO ReloadTime.qvd;

Now load this QVD in the new Qlikview file and display this datetime.

Only(LastReloadTime)

Hope this helps you.

Regards,

Jagan.

Anonymous
Not applicable

Agni,

Just define Reloadtime() or Now() as a field in your table and then call it as a Binary.

You will get the last reloadtime.

Hope this will help.

PradeepReddy
Specialist II
Specialist II

Hi Agni,

Please Find the attached applications.

First I have created the 'Test1' application, Later I have created the other application 'Test2'.

I hope it caters your requirement.

Thanks,

Pradeep