topic How can I get the reload time elapsed ? in QlikView

How can I get the reload time elapsed ?

Thu, 06 Aug 2009 17:03:03 GMT

Hi every body.

Is there any way to find the "Reload Time spent", I mean the time elapsed for the last reload not the hour when the last reload was achieved (that last point is covered by the reloadTime() function).

I don't find any properties even in the Macro's API. Did I missed something ?

Can I find that information in a .mem file ?
Or maybe I should try to parse the Server / Publisher logs ?

Is someone have an idea ?

Best regards

P.S : context : I'm trying to create file statistics upon a list of qvw. I've manage to get almost all I need (thanks to Community users 🙂 except that "reload time elapsed"

How can I get the reload time elapsed ?

Thu, 06 Aug 2009 17:38:08 GMT

Bertrand,

it´s easy to calculate it.

Use variables like:

At the beginning of your script Let vScriptStart = Now();

And on the end: Let vScriptEnd = Now();

as example.

Do have the "Server Performance" application available? This application reads out QlikView server log files.

Rainer

How can I get the reload time elapsed ?

Thu, 06 Aug 2009 17:44:14 GMT

Set a variable to the value of now(1) at the start of the scrip and another to now(1) at teh end. The now function returns a timestamp so you can use date/time functions to calculate the difference.

Regards,

Gordon

How can I get the reload time elapsed ?

Thu, 06 Aug 2009 18:45:02 GMT

Thanks everybody.

but (see the P.S part in my first post). my final goal is to read that informations in other Qvw not only in the current qvw.
That why i'm looking for a property or a log with that information (or else I will be forced to calculate the reload time manually in each qvw analysed).

Best regards

How can I get the reload time elapsed ?

Thu, 06 Aug 2009 18:59:49 GMT

Bertrand,

turn on for every QlikView application "Generate Logfile" (Document Properties => General Tab).

Logfile name will be: MyApplication.qvw.log

Here you find the information you need:

23.07.2009 09:15:55: Start der Skript-Ausführung
23.07.2009 09:15:55: QlikView Version:8.50.6261.5
23.07.2009 09:15:55: 0002 SET ThousandSep='.'
.

23.07.2009 09:15:55: 4 Felder gefunden: DocumentNo, ActualDate, ActualTime, ActualStatus, 3 Sätze erhalten
23.07.2009 09:15:55: Ende der Skript-Ausführung

Rainer

How can I get the reload time elapsed ?

Thu, 06 Aug 2009 19:05:56 GMT

Ok thanks,

That's what I need