Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
rwunderlich

QlikView Document Analyzer v3.5 Available

Version 3.5 update to the free QlikView Document Analyzer tool is available for download

Qlikview Cookbook: QV Document Analyzer http://qlikviewcookbook.com/recipes/download-info/document-analyzer/

Changes for version 3.5:

- Corrected file detection when using UNC path ("\\") to QVW.

- Added new computed field, "Expression Table Count".

- Improved function identification logic to find more functions.

- Added "Like Objects Count" attribute for Objects, identifying candidates for linked objects.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

25 Replies
Jose_Del_Rio
Employee
Employee

Hi Rob, I've been a follower of this document for a while, it is a great tool, every time I want to check something in performance, my first step is to run this tool. Great contribution!

I'm trying to run it over a QVW I have that contains a very complex UI design. I can create the prj Directory with no problem, but when I try to Extract the metadata, the Macro Module is opened and I cannot run it. I already show all the Tab row and remove the hidden script, but still does not run. Any ideas why is not extracting metadata? What else could it be? The file has section access, thousands of text boxes and many actions.

rwunderlich
Author

Hi Jose,

It's choking in the Module somewhere, but you can't tell where when you launch it from the button.  Here's how to determine where it's failing.

1. Start by opening DA fresh.

2. Open the Module (Ctrl-m)

3. Click "ProcessDocument" in the left pane.

4. Press the "Test" button and wait.

Eventually it should fail and you will see an error message at the top and it will stop at the failing module line.  Give me those two pieces of info and we'll go from there.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Jose_Del_Rio
Employee
Employee

I fount the error. It says Permission denied in this line:

Set openOutputFile = objFSO.OpenTextFile (filename, ForWriting, True, -1)

from the function: Function openOutputFile(filename)

I have run the QV as administrator, I have changed the folder to see if there are some restrictions in the folder and still giving me this error, and only with this file.

rwunderlich
Author

Try this. Locate the metadata folder for this qvw. It should be

C:\Users\userid\AppData\Local\Temp\qvwork\yourqvw

where "yourqvw" is the qvwname.

Delete the folder and try again.

I would not recommend running DA as Administrator.

-Rob

stvegerton
Creator III
Creator III

Hi Rob, What is the unit of measure on the Objectid & CalcTime chart within the Expressions Tab? Milliseconds?

+I'm very happy to hear you're working on a version for Sense!

rwunderlich
Author

Steve,

Yes, the unit of measure for calc time is milliseconds.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Anonymous
Not applicable

Hi Rob, I tried version 3.5, drop field statement (unused fields) contained the field "Empfänger" that is only used within recipients list

I created a prj directory...

rwunderlich
Author

I may not be picking fields used in a recipient list. I'll see if I can fix that in the next version.


Rob

rwunderlich
Author

Document Analyzer V3.6, released today, will detect fields used in Alerts.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com