QlikView Document Analyzer update 3.9

[rwunderlich]

Version 3.9 of QlikView Document Analyzer is available for download here:

http://qlikviewcookbook.com/recipes/download-info/document-analyzer/

This version includes the following updates. 

- A prj directory is no longer required to get full analysis. The prj recommendation is removed from the Main sheet.
- Changed Per User memory calc from Type=Field State to Class=State Space. This is the correct number,which is larger than previously shown.
- Added contribution from Marcel Hug to analyze use of Module Subs and Functions.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[rwunderlich]

1. Does the module have System Access? (Ctrl-m > Requested Module Security)

2. Does it fail when analysing any qvw, or just this qvw?

-Rob

[radugherga]

1. It has System Access and all macros are allowed.

2. It fails for any QVW. I just tried with a new qvw with only one table and:
- on the first run the error is:
Object doesn't support this property or method: 'sheet.GetProperties.StateName'
on line 665  sheetsFile.WriteLine( _
- on the second run the error is:
Permission denied
on line 1103  Set openOutputFile = objFSO.OpenTextFile (filename, ForWriting, True, -1)

Radu

[rwunderlich]

There appears to be a problem writing to your temp folder.  As a workaround:

1. Create a new directory like "c:\dawork"

2. Open the DA module (Ctrl-m) and change line 1046 from 

GetOutputDir = GetTempPath & "\qvwork\" & basename & "\" 

to 

GetOutputDir =  "c:\dawork\" & basename & "\" 

Save the DA qvw and retry.

-Rob

[radugherga]

Unfortunately that does not work either.
I will try it on another computer and see if I get the same errors.
From what I have read online, it could have something to do with the admin rights, but that would be strange since my Windows user has Administrator privileges.

Radu