topic Re: QlikView Document Analyzer v3.5 Available in QlikView

QlikView Document Analyzer v3.5 Available

rwunderlich — Fri, 10 Mar 2017 22:05:06 GMT

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

Re: QlikView Document Analyzer v3.5 Available

Jose_Del_Rio — Thu, 23 Mar 2017 14:11:03 GMT

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.

Re: QlikView Document Analyzer v3.5 Available

rwunderlich — Thu, 23 Mar 2017 18:25:07 GMT

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

Re: QlikView Document Analyzer v3.5 Available

Jose_Del_Rio — Thu, 23 Mar 2017 23:46:55 GMT

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.

Re: QlikView Document Analyzer v3.5 Available

rwunderlich — Fri, 24 Mar 2017 14:53:22 GMT

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

Re: QlikView Document Analyzer v3.5 Available

stvegerton — Thu, 20 Apr 2017 12:52:57 GMT

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!

Re: QlikView Document Analyzer v3.5 Available

rwunderlich — Fri, 21 Apr 2017 16:56:07 GMT

Steve,

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: QlikView Document Analyzer v3.5 Available

Anonymous — Thu, 04 May 2017 05:42:27 GMT

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

Re: QlikView Document Analyzer v3.5 Available

rwunderlich — Thu, 04 May 2017 11:44:37 GMT

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

Rob

Re: QlikView Document Analyzer v3.5 Available

rwunderlich — Mon, 26 Jun 2017 19:16:58 GMT

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: QlikView Document Analyzer v3.5 Available

Anonymous — Mon, 26 Jun 2017 20:06:57 GMT

thanks Rob!

Re: QlikView Document Analyzer v3.5 Available

Anonymous — Fri, 24 Aug 2018 16:00:04 GMT

Is this still available for download? When I click on the link, it indicates file not found.

Re: QlikView Document Analyzer v3.5 Available

rwunderlich — Fri, 24 Aug 2018 20:00:38 GMT

Yes, Document Analyzer is stall available. The current version is 3.8. The download link works for me.

Try going directly to the "Tools" section of Qlik Cookbook and select it from the list.

Tools | Qlikview Cookbook

-Rob

Re: QlikView Document Analyzer v3.5 Available

alan_richmond — Tue, 02 Oct 2018 22:32:30 GMT

Hi Rob,

I also have a complex app with thousands of objects.

After running test with Process Document mine stopped at this place

set openOutputFile with Permission denied at the top

Regards,

Alan

Re: QlikView Document Analyzer v3.5 Available

alan_richmond — Sun, 07 Oct 2018 22:27:38 GMT

Hi Rob,

I have the Analyzer 3.8 pointing at a complex large qlikview document

All the metadata in the qvwork directory seems to have been created but the process doesn't seem to complete. I have had it running over the last weekend and it still has not completed.

What can I do to see where its 'locked' or whats needed to be done.

Alan

Re: QlikView Document Analyzer v3.5 Available

rwunderlich — Mon, 08 Oct 2018 15:45:36 GMT

Take a look at the DocumentAnalyzerExtract.log file in the metadata directory. What's the last entry in the log?

-Rob

Re: QlikView Document Analyzer v3.5 Available

alan_richmond — Mon, 08 Oct 2018 21:24:44 GMT

4/10/2018 1:56:43 PM: Work Directory C:\Users\alanr\AppData\Local\Temp\2\qvwork\Sales (Combined) backupForQVAnalyzer\

Regards,

Alan

Re: QlikView Document Analyzer v3.5 Available

alan_richmond — Mon, 08 Oct 2018 21:36:19 GMT

Rob are you able to tell the app where to save the metadata because its not in the location that the log has identified

Regards,

Alan

Re: QlikView Document Analyzer v3.5 Available

rwunderlich — Mon, 08 Oct 2018 22:08:54 GMT

C:\Users\alanr\AppData\Local\Temp\2\qvwork\Sales (Combined) backupForQVAnalyzer\

is this directory created?

Re: QlikView Document Analyzer v3.5 Available

alan_richmond — Mon, 08 Oct 2018 22:48:55 GMT

No, it looks like I have run out of disk on my C Drive, Ill add some more and give it a try, thanks Rob