Document Analyzer V3.0 Update Available

[rwunderlich]

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

[rwunderlich]

Start by eliminating fields that are not used. See the "Fields" sheet and the suggested DROP FIELDS statement. Note this is a suggestion, you should review the list.

Also follow the link on the "Introduction" sheet if you want to learn more about optimizing QV apps. You can also join us at the Masters Summit for Qlik‌ in Boston Oct 23-25 for a detailed overview of Qlik Application performance factors and a hands-on tuning lab.

-Rob

[Anonymous]

can i attend this online?

as am located in india

[Anonymous]

am seeking for your guidance as i need to do this in 2 days ,so it would be really helpful to share few more points on this please

[rwunderlich]

For the education link listed on the Intro sheet, there are currently no online classes scheduled.  The next class will probably be in December.

The Masters Summit for Qlik is local only, there is no on-line option.

It you are not familiar with QV performance tuning I suggest to try reading these forums for tips or engaging a experienced performance specialist.

-Rob

[sarangmmehta]

Hi Rob,

I am facing an error "Bianary load is not allowed on (location path of the application)".

Request you to help me solve this issue.

Regards,

Sarang M. Mehta

[prieper]

you (resp the data owner) need to change the properties of the document, to which you refer with BINARY LOAD

[Anonymous]

I am assuming the "%field" [Reference Filter] list box is for fields on the actual tables loaded from qvd's or data sources. Please clarify.

[Anonymous]

Very handy tool and makes life with data models much simpler.

[rwunderlich]

You are correct.  The %FieldLink represents the table data.  I need it in the model but it's probably not a very useful thing to have in the listbox. I may filter it out in a future version.

-Rob

[Anonymous]

Thanks Rob. That sounds good.