topic How do I display the last reload time when opening a Qlikview doc? in QlikView

How do I display the last reload time when opening a Qlikview doc?

Anonymous — Thu, 07 Apr 2011 11:09:49 GMT

Hi,

I have written a simple VBscript macro in the Edit module:

sub

dim

set

msgbox

end

Which tests out absolutely fine.

I have changed the Requested Module Security and Current local security to System Access.

I have added it to the Document properties in the Triggers OnOpen list of actions:

Run Macro Macro name Reload_data

Clear All

Activate Sheet Sheet ID SH01

I have set the security of the document to Macro Override Security

sub ("Last Time Data Was Reloaded in the System was " & LastReloadedTime & ". (Data is automatically reloaded at 13:00 Mon-Sat.)" ) adoc=qvdoc.getproperties QVDOC=ActiveDocument LastReloadedTime Reload_date

I have saved, closed, exited and reopened Qlikview but it will not display my message box created in the macro - any ideas anyone with more experience than myself?

How do I display the last reload time when opening a Qlikview doc?

Thu, 07 Apr 2011 11:29:51 GMT

Hi,

Instead of messagebox, you can show last reload time in textbox.

'Last reload on - ' & reloadtime()

Thanks & Regards

How do I display the last reload time when opening a Qlikview doc?

udaya_kumar — Mon, 16 Jan 2012 07:22:39 GMT

hi upendra,

do i need to use this 'Last reload on ' & reloadtime() code in expression or i should create macro for this?

i should show the last reload time in textbox, how can i show that?

How do I display the last reload time when opening a Qlikview doc?

vijay_iitkgp — Mon, 16 Jan 2012 07:30:47 GMT

You can write ='Last Reload On - '& Reloadtime() in text box. it will show you result.

How do I display the last reload time when opening a Qlikview doc?

udaya_kumar — Mon, 16 Jan 2012 08:44:58 GMT

i got it,

thanks for the help

Re: How do I display the last reload time when opening a Qlikview doc?

Fri, 23 Aug 2013 06:17:56 GMT

I want to display vRunTime as message box , Kindly let me know how can i do this

LET vStart = num(now());

Store * from tempqvd into tempqvd.qvd (qvd) ;

LET vRunTime = interval(now() - $(vStart),'mm:ss');

Re: How do I display the last reload time when opening a Qlikview doc?

stevedark — Fri, 23 Aug 2013 07:19:52 GMT

HI Srinivasan,

I would recommend using a simple Text Object with the run time in. If you want a dialog box that you click to close you could make the Text Object conditional and have an action which on click changes a variable to make the text box disappear (see my blog post on buttons http://www.quickintelligence.co.uk/qlikview-buttons/ ).

Personally though, I have variables I set in every load script then the following in a text object at the foot of the first tab of every document:

='Last load date: ' & date(vLastLoadStart, 'DD MMM YYYY hh:mm:ss') & '

Load duration: ' & date(vLastLoadEnd - vLastLoadStart, 'hh:mm:ss') & '

Number of Rows: ' & num(vNoOfRows, '#,##0') & '

Version Number: ' & num(vVersionNumber, '#,##0.00')

Typically this is in a small font in a light colour, but if someone wants to find that information it is there.

Regards,

Steve

http://www.quickintelligence.co.uk/

Re: How do I display the last reload time when opening a Qlikview doc?

Fri, 23 Aug 2013 07:32:05 GMT

Hi Steve,

How do you define your variables (vLastLoadStart, vLastLoadEnd, vNoOfRows and vVersionNumber) in your script?

Regards

Fredrik

Re: How do I display the last reload time when opening a Qlikview doc?

stevedark — Fri, 23 Aug 2013 07:35:50 GMT

Hi Fredrik,

At the start of the script I set these:

let vLastLoadStart = now();

let vNoOfRows = 0;

let vVersionNumber = 0.01;

After each table load I increment this:

let vNoOfRows = vNoOfRows + Alt(NoOfRows('Bridge'), 0);

And then and the end I set the final variable:

let vLastLoadEnd = now();

That populates everything that is required for the text box I referenced above.

-Steve

Re: How do I display the last reload time when opening a Qlikview doc?

Fri, 23 Aug 2013 08:45:58 GMT

Thank you Steve.

Your solution with the reload time is very useful for me.

Regards

Fredrik

Re: How do I display the last reload time when opening a Qlikview doc?

adam1988 — Mon, 03 Feb 2014 15:52:44 GMT

Hi Steve, and what about VerionNumber? Do you store it somehow or you just change it manually?

Re: How do I display the last reload time when opening a Qlikview doc?

stevedark — Mon, 03 Feb 2014 16:37:10 GMT

Hi Adam,

This is just changed manually. These variables sit just under the header on the load script, where developers are expected to enter dates and comments of any changes. If the change requires a change of version number they would be expected to update this in the code.

You could automate it, I guess, but I always find that simple works best.

Cheers,
Steve

Re: How do I display the last reload time when opening a Qlikview doc?

kamikhan — Wed, 22 Jan 2020 10:34:56 GMT

HI! i need to ask one thing i have 2 sheets in qlikview one sheet i update daily . and auto reload time showing.
but 2 sheet i will updated monthly. or weekly but user consider sheet 2 also update today. so i have question to how can i showing both sheets on different updated time.