I've posted a major update "V2" to the Document Analyzer tool. It is available for download in the Tools section of QlikviewCookbook.com here Document Analyzer.
The primary function of Document Analyzer remains to identify unused fields that can be removed from your model. It has been expanded to assist in identifying slow charts.
There are a number of improvements over the 1.15 version, including bug fixes, a new UI, object calc times and improved analysis of variable and expression usage.
An important change is that only qvws that have been saved in QV10SR2 or later may be analyzed with this version. If you need to analyze an older document, save it first in QV10.
if a prj directory exists, it will be leveraged for the analysis. This can speed up the analysis run for documents with a lot of objects.
Use this thread if you have comments or questions. Enjoy.
Thanks Rob, that pointed me in the right direction. I had to rerun the tool and delete one chart after the other before the Extract process completed. Four charts in total had to be deleted. I'm not sure what is wrong with those charts, but I'm glad I know where to look now.
I'd like to look at those charts. Can you create a copy of your document that has only those four charts? And then delete all the data - File, Reduce, Remove all Values. You can delete the script also. Then post it here. If you would prefer not to post, contact me at Contact | Qlikview Cookbook and I'll give you an email address.
Whenever i click on Extract Metadata (after putting the correct path), it just opens up the Macro editor and stops there. It also opens the QVW file. Then it does nothing, pls help. QVW size is around 1 GB.
Make sure you have granted System Access to the Module. Then use this technique to determine where the extract is failing:
It sounds like something is failing in the module. Here is how you can identify for me exactly where it's failing.
1. Open the Module (Ctl-M)
2. Click "ProcessDocument" in the left-hand pane.
3. Click the Test button. The macro will run but stop on error and post an error message on top. Let me know what the error is and what line it stopped on.
