QlikView Document Analyzer v3.5 Available

[rwunderlich]

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

[Jose_Del_Rio]

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]

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]

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]

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]

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]

Steve,

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[Anonymous]

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]

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]

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com