Version 1.4 of the Qlik Sense Document Analyzer (QSDA) tool is now available for download here.
If you are not familiar with QSDA, it’s a free application profiling tool for Qlik Sense that can help you identify items such as unused fields, poorly performing expressions and data model problems.
I’m pleased that Mike Steedle of Axis Group has joined me as co-developer of QSDA. Mike contributes his many years of experience in profiling and tuning Qlik applications.
Here’s what’s new in version 1.4:
- Installer improvements. The correct directory for Connectors and Apps is automatically detected.
- New attribute “ObjectIsExtension”. Possible values are:
- False – not an extension.
- True – object is an extension but not a widget.
- Widget – object is a widget.
- Missing – object is an extension, but extension is not present on server.
- Unused Master Visualizations, and the Dimensions and Expressions therein, are now extracted and processed.
- DimensionLabel field added to “Dimensions” table.
- New table “Bookmarks”. Bookmarks are now extracted and linked to Fields.
- MB Constant changed from 1000*1000 to 1024*1024. This means these numbers now scaled in MB will have slightly smaller values than previous versions.
- Calc Time is now displayed in seconds instead of milliseconds.
- Dimensions and Expressions summary added to Objects sheet.
- Some analysis of the data model is performed, and the results and recommendations expressed as flag fields. New sheet “Flag Summary” will display an overview of found conditions.
- Color highlighting of detected problems.
- Reorganization of sheets and sheet layouts.
- Addition of a “Glossary” sheet provides descriptions for flags.
The installer currently only supports installation on Qlik Sense Desktop, although you can analyze applications on Enterprise Server.
Improving the server analysis capabilities and possibly a server install will be a focus of the next update.
If you have general usage questions on QSDA, please use the comments section here or Qlik Community.
If you have a bug to report, use the issue tracker.
I hope you find QSDA useful. I’m excited to see it maturting and pleased to have the help from Axis Group.
-Rob
Thank you very much Rob (and Axis Group) for the continuous evolution of this important tool!
Hello,
Does this tool recognize whether a field is used in the set analysis of an expression?
Best Regards,
Miika Hakala
Yes, it will identify fields anywhere in the expression, including the set.
It’s been a pleasure working with you on this, Rob, and thank you for your hard work on the connector and the QVF. I’m looking forward to seeing what additional insights we can get from the new metadata you have added to the connector in 1.4!
Hi Rob,
I am running into an issue while attempting to install. Can you please help? I’m trying to install to my C: drive.
This is the error message I’m receiving:
“Z:\Documents\Qlik\Sense\QS Document Analyzer V1.4.qvf
An error occurred while trying to create a file in the destination directory: Error 3 The system cannot find the path specified.”
The installer seems to think your Qlik apps are on the Z drive. Do you get the dialog during install that lets you set the path?
No, I’m not presented with that option. Once I run the executable the only option is to install. No path selection option is available.
The installer is determining — incorrectly it seems — that your Qlik Sense apps are on the Z: drive. The 1.5 update which will be available soon will allow editing of all install paths.
Hi Rob,
thank you for your valueable contribution. The Document Analyzer helps us a lot to identify weak spots.
Unfortunately I can’t connect to Qlik Enterprise and the following message appears in app list field:
-Cannot connect to Qlik Sense
-Connection failed after 4 attempts. Error message: Der angegebene Host ist unbekannt*
*Unknown Host
Any idea what I’m doing wrong? Maybe any settings in the QMC are necessary?
I tried to enter another host, but after that I get the following error message:
“The remote certificate is invalid according to the validation procedure”
Hello Gregor,
The 1.5 version will fix the certificate error. 1.5 should be released next week, but in the meantime here is a link to the beta version of you want to try it. http://qlikviewcookbook.com/download/qs-doc-analyzer-v1-5-beta/
Hello Rob,
thank you very much! It works perfect with the new version now. 🙂
Hi Gregor,
Only NTLM (windows passthrough) authentication is currently supported. Is your server expecting something other than NTLM auth?
Gregor, did you find a solution? Im facing the same problem,
br
Paul
I am using QlikView version 12.20.21000.0
Using Document analyzer 3.9 , I have extracted metadata, there are no dimensions and expressions extracted, though there are many in my QVW file.
Can you please clarify this?
Have you reloaded?
Yes I followed the right process.
I encountered this problem, only when my QVW file is on a Network Drive. Anyhow, when I moved my file to a local machine, it is working as expected.
This is an amazing tool !!!