topic Need qvd count from the folder as per the application in QlikView

Need qvd count from the folder as per the application

deepakqlikview_123 — Fri, 15 Nov 2024 23:27:30 GMT

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

Re: Need qvd count from the folder as per the application

edwin — Mon, 14 Dec 2020 12:54:27 GMT

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

Re: Need qvd count from the folder as per the application

deepakqlikview_123 — Wed, 16 Dec 2020 12:08:04 GMT

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

Re: Need qvd count from the folder as per the application

pradeep_s — Thu, 07 Jan 2021 16:20:03 GMT

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#M12050

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-Analyze-QVW/tac-p/1753742#M12020

Thanks

Pradeep