QSDA Pro is the next generation of my Document Analyzer tool for Qlik Sense. I published the first Document Analyzer for QlikView in 2009 followed by the Qlik Sense version in 2017. I think it’s fair to say both are the most widely used Qlik developer add-on tool.
Qlik Sense Document Analyzer (QSDA) has been extremely useful. But it’s had some limitations, especially in the server environment. I’ve wanted to address those shortcomings, and now I bring you my response :
QSDA Pro is a completely rewritten standalone app that provides features of the current QVF based QSDA and more. QSDA Pro can analyze and provide advice on apps in QS on Windows, Qlik Cloud, and QS Desktop.
QSDA can help you produce cleaner, smaller and faster apps by identifying:
- Unused resources, such as fields, that can be removed.
- Errors in your app such as missing fields, syntax errors or missing key values.
- Bad practices and recommendations on how to remediate.
- Highlight performance hotspots.
QSDA Pro can do all of the above and more for public sheets and private sheets. “Is anyone using this field in a personal chart or bookmark?” is no longer an unknowable thing.
QSDA is also your goto companion for those ad hoc tasks like modifying use of a field. Maybe a renaming or dividing by 1000.
Where am I using the field “Company Name”? Easy. Filter on the field name and I can instantly see the field is not referenced by Variables, but it is used in 22 Charts, 23 Dimensions and 5 Expressions. Oh and 1 Bookmark.
What Charts where? Click Viz on the ribbon to get a list. I can explore the chart Dimensions and Expressions there or click a link to open the associated sheet in the Qlik Sense Hub.
QSDA is smart! It can determine that all four of these measures calculate the same thing, even with differences of variables, casing and whitespace. And it recommends you should settle on one Measure while very helpfully showing how many times each variation is used to help you in your decision.
In the coming weeks I’ll be posting more about the capabilities of QSDA Pro. I’ll also be responding to feedback on the QSDA Pro Community site.
QSDA Pro is currently in public beta testing and is free to use during the testing period, which is expected to last for several months.
You can learn more about QSDA Pro and download your own copy.
Licensing terms for the supported production version will be announced later. There will be a free tier which may have limits on volume and features.