Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Document Analyzer V3.0 Update Available

V3.0 of QV Document Analyzer is now available for download with these changes:


  • Fields used in Search Objects are extracted as Named Dimensions. “List of Fields” are processed, but Wildcarded fieldnames are not expanded.
  • Results are optionally written to a QVD during reload. The DA datamodel has been reorganized to include a “%KeyDocument” field that identifies a unique analysis.
  • Tables to Field associations are now built uisng a Binary Load of the target doc as workaround for missing hidden field associations from the API.
  • Date formats are now in YYYY-MM-DD format.
  • A new “Analysis Title” option is available on the Main sheet.
  • Added Analysis Name, Date & Title to caption of analysis ribbon.
  • Added Calc Time to analysis ribbon.
  • The Extract Log is now stored in the Document Meta folder, instead of the temp folder. The display of the log has been moved to a separate “Extract Log” sheet.
  • Field Comments are now extracted and reported on the Fields sheet.
  • “Expression Enabled” is now a property for chart expressions and is present as a filter on the Expressions sheet.
  • Added test for QV12SR1 in reload and stop the script if detected. That release will not work to reload DA.

You can download this latest version here:

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

62 Replies
jrepucci15
Creator
Creator

Rob,

FYI (using DA v3.4)

tab: Groups, table: "Objects Using a Group"

I added SheetName so I had visibility where the groups were being used.

John

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP
Author

Thanks, I'll consider adding that to 3.5.

-Rob

Anonymous
Not applicable

am trying to use its gvng an error of file not found

Cannot open file '\\PFFIL006\s.qvw

BINARY .\PFFIL006\s.qvw

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP
Author

Can you post the relevant lines from the Document Log?

-Rob

Anonymous
Not applicable

Hey Rob,

Any updates on a QS version of the document analyzer? Really appreciate all your work!

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP
Author

Radio silence....working on it but no firm date.

-Rob

markp201
Creator III
Creator III

Thanks Rob for this update.  We primarily use Qlik Sense here and what we've done in the past is copy the data model script (typically optimized QVD loads) to a qlikview document then use the analyzer to get feedback on at least the data model.  One suggestion: could a page be added on hardware recommendations - cpu & memory?  I have to switch between the analyzer and another document where I enter the app size, multiplier & number of users to get an idea if the hardware is sufficient.  Thanks again.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP
Author

paulyeo11
Master
Master

Hi Rob

I have try the QV doc analysiser. i copy my QVW file to C:\TEST\

C:\TEST\WORKING VER 003.qvw

I paste the above script into the Step 1 box.

I get the below error code :-

line 603 sheetsFile.WriteLine( _

When i click okay , i click on Extract metal data , again i get the below error code :-

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

Hope some one can advise me where i go wrong ?

Paul Yeo

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP
Author

It sounds like you have a permissions issue with the temp directory.  Try deleting the folder:

C:\Users\yourUserid\AppData\Local\Temp\qvwork