Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

MVP & Luminary
MVP & Luminary

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
Employee
Employee

Re: QlikView Document Analyzer v3.5 Available

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.

MVP & Luminary
MVP & Luminary

Re: QlikView Document Analyzer v3.5 Available

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

Employee
Employee

Re: QlikView Document Analyzer v3.5 Available

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.

MVP & Luminary
MVP & Luminary

Re: QlikView Document Analyzer v3.5 Available

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
Contributor III

Re: QlikView Document Analyzer v3.5 Available

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!

MVP & Luminary
MVP & Luminary

Re: QlikView Document Analyzer v3.5 Available

Steve,

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

robin_hausdoerfer
Valued Contributor III

Re: QlikView Document Analyzer v3.5 Available

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...

MVP & Luminary
MVP & Luminary

Re: QlikView Document Analyzer v3.5 Available

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


Rob

MVP & Luminary
MVP & Luminary

Re: QlikView Document Analyzer v3.5 Available

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com