Need qvd count from the folder as per the application

[deepakqlikview_123]

Hi All,

We need the overall QVD count for the application.

We have a variety of folders where the different layers of QVDS are stored.

Is there anything that qik has provided for the same?

Thanks

[edwin · Accepted solution]

one definite way is to load each QVW and accumulate the number of rows in a variable.

[deepakqlikview_123]

Do we have a  qlikview reconciliation Dashboard for the same? If so can we have a link.

[pradeep_s]

Hi Deepak,

There 2 tools for your need.

1. Use Directory Scan application - This will scan the files in the folders and will gives you the list of files along with size/created time, QVD meta data - which document has created the QVD and row count.  It has snapshotting feature which enables you to monitor the changes to the size of your files over a period of time. https://community.qlik.com/t5/QlikView-Documents/QlikView-Directory-Scan-Application/tac-p/1772400#M...

2. Use Qlik Script log analyzer tool: This tool scans through the script logs and tells you about all data sources for the app, records fetched and time consumed for each load step, optimized QVD loads etc..  https://community.qlik.com/t5/QlikView-Documents/Qlik-Script-Log-Analyzer-A-near-Complete-tool-to-An...

Thanks

Pradeep