topic Re: QVD information in QlikView

QVD information

ahamers — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: QVD information

devarasu07 — Sat, 13 Jan 2018 16:30:10 GMT

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

Re: QVD information

rubenmarin — Sat, 13 Jan 2018 17:39:39 GMT

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?

Re: QVD information

asgardd2 — Mon, 15 Jan 2018 09:56:58 GMT

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.