topic Re: Last Save time on app in QlikView

Last Save time on app

priyarane — Mon, 02 Mar 2015 12:41:33 GMT

Hi Experts,

Is there any way that to know last save time on application like reload time(reloadtime()).

thank you,

Priya

Re: Last Save time on app

Roop — Mon, 02 Mar 2015 13:19:24 GMT

Now() allows you to do this.

Returns a timestamp of the current time from the system clock. The timer_mode may have the following values:

0 Time at previously finished reload (not currently ongoing reload)
1 Time at function call
2 Time when the document was opened

Re: Last Save time on app

Mon, 02 Mar 2015 13:28:00 GMT

Hi Rupert,

If you don't mind could you please explain in detail? to get save time

Thank you

Re: Last Save time on app

Roop — Mon, 02 Mar 2015 13:32:18 GMT

If you create a textbox with:

=now(0)

That will give you the time when previous reload finished. This also appears in the bottom right of the QlikView desktop screen.

= now(1)

Time when a function call was made

=now(2)

Time that the application was openend

Re: Last Save time on app

Mon, 02 Mar 2015 13:46:58 GMT

Got it Rupert,

so now, how to get save time. Here the requirement like - document saved on 03-mar-15 7.15 Pm and closed now user want to see that last refreshed time(reload + refreshed) reload we have(reload()) but save time?

thank you

Re: Last Save time on app

Mon, 02 Mar 2015 14:17:28 GMT

Could you check and community know if filetime('yourqvdoc.qvw') helps?

Re: Last Save time on app

Roop — Mon, 02 Mar 2015 14:18:55 GMT

I think that those are the only available types. Anything else you would have to create yourself. You could possibly do something similar within a macro.

Re: Last Save time on app

awhitfield — Mon, 02 Mar 2015 14:47:57 GMT

Hi,

a simple way is the use a text box with something like:

='Last Updated : '&reloadtime()

Which would give you

Re: Last Save time on app

Mon, 02 Mar 2015 14:58:23 GMT

Hi Andrew,

Not reload time, need to know about SAVE TIME. For script part we will reload and what ever changes made at application no need to reload, so If we made any changes at application part(refresh time).

Re: Last Save time on app

Mon, 02 Mar 2015 14:58:58 GMT

Hi Guru,

I didn't get it. Could you please explain in brief?

Re: Last Save time on app

Mon, 02 Mar 2015 15:01:36 GMT

Thanks Rupert,

I am new to QV and no macro knowledge.

Re: Last Save time on app

Roop — Mon, 02 Mar 2015 15:04:56 GMT

I think that I would do this slightly differently.

The problem is that the date of the last "Save" will disappear as soon as you reload the application. I would probably create a manual file of the versions separately. This could then be used to calculate any time differences.

The fields I would use are as follows:

Version

Date/Time of Version

Descripton of Version

In this way you could use the Max(Date/Time of Version) in any time calculations

All the best

Rupert

Re: Last Save time on app

priyarane — Mon, 02 Mar 2015 18:32:12 GMT

cHECK

Re: Last Save time on app

Roop — Tue, 03 Mar 2015 12:18:46 GMT

Password protected spreadsheet ! Sorry, cannot review

Rupert