Discussion Board for collaboration related to QlikView App Development.
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?
one definite way is to load each QVW and accumulate the number of rows in a variable.
View solution in original post
Do we have a qlikview reconciliation Dashboard for the same? If so can we have a link.
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...