QVD information

[ahamers]

I have one QVW document that generates all my QVD files.

Is it possible to store the tabel, kolom and a count of records-information in a tabel so I can show it in the same document on a dashboard witch tables are stored and how many.

Even the reload time if it is possible.

[devarasu07]

Hi,

by using system table info you can get the desired result. for more details you can check below article. Thanks

System fields ‒ QlikView

Hope it helps

Regards,

Deva

[rubenmarin]

Hi, this can be done generating another qvd with the info about the each table before being exported to qvd.

Before STORE and DROP of each qvd add the require info to the table, at the end of script store this table in another qvd.

Is this what you are looking for?

[asgardd2]

Hi!

For analyze the reload time you can use:

     1. Application Script Log Analyzer (Tools | Qlikview Cookbook)

     2. Functions in Script, like this:

LET vReloadTimeTab = now();
LET n = 0;
LET vReloadTime = now();

SUB TraceTime //use 'call TraceTime' to check the elapsed time from the last mark

    LET n = n + 1;
    LET vSpred = Time(now() - vReloadTime, 'hh:mm:ss');
    LET vReloadTime = now();
    TRACE $(n). Reload Time: $(vReloadTime) - Duration: $(vSpred);

END Sub


SUB TraceTabTime //use 'call TraceTabTime' to check time of reload tab

    LET vSpredTab = Time(now() - vReloadTimeTab, 'hh:mm:ss');
    LET vReloadTimeTab = now();
    TRACE;
    TRACE Reload Time TAB: $(vReloadTimeTab) - Duration: $(vSpredTab);
    TRACE;
    LET n = 0;
    LET vReloadTime = now();    

END Sub;

     You can modify this functions to store time of reload in the qvd or txt file.