QlikView List Box Search String Generator Excel Macro.zip
QlikView Data Analyzer v2.0.qvw
I am glad to announce the release of QlikView Data Analyzer v2.0 which contains advanced features like Set Analysis Generator and Charts Generator. This is the next version to the First version released in March 2018. The objective of QlikView Data Analyzer is to Automate repetitive tasks as much as possible and increase the productivity and efficiency of QlikView Dashboards Development!
This application can be used for developing new QlikView Dashboards by quickly generating expressions and Charts. It is also fully portable to copy these features into any existing QlikView applications and no reloading or script changes required as all the functionalities are handled via Macros. Another area where the Data Analyzer is very helpful is for validating and testing the data
QlikView Data Analyzer v2.0 has the following features (Please see the attached User Guide for further info):
Create Table Box
Create List Box
Create Text Box
Normal / Wildcard Search
Set Analysis Generator
Variables List Generator
ASCII Characters List
Clean Up Features
Set Analysis Generator
A Set Analysis Expression can be quickly generated with just few clicks and the result can be see instantly. This expression can be copied and used in any other charts as required. Also this generated expression can be used to generate the required charts with the Charts Generator feature
Charts can be generated on the Fly by making use of the generated expression by the Set Analysis Generator
This feature shows the Profiling results of a Field and also the Tables Summary with the number of columns and number of rows for all the Tables in the Data Model.
Variables List Generator
This feature allows the generation of the list of all the variables in the application. The purpose of which would be to see all the variables in one place and also to amend them in the same object and also to copy and use them in writing advanced variable-based expressions.
Follow these steps for copying the objects into any QlikView Application:
Create a new Tab in your existing application and rename it as "Data Analyzer"
Press Ctrl + Shift + s and Copy all the objects (Ctrl + a and Ctrl + c) in the "Data Analyzer" tab ofQlikView Data Analyzer Application and paste in the "Data Analyzer" tab by pressing Ctrl + v of your application
PressCTRL + Min the QlikView Data Analyzer Application and copy all the Macro code and paste that macro code into the Macro window of your application.
Press Reset button to create all the Variables required by the Data Analyzer Objects in order to perform as required
Click on Set Analysis Generator button twice to enable the show / hide functionalities (This pressing of button twice is only required to be done once for the first time after pressing the Reset button as this will enable the show / hide functionality of the button)
To enable the Variable List Generator functionality please see page 3 of the attached User guide and follow steps 8 to 12
QlikView List Box Search String Generator Excel Macro
I have also developed a QlikView List Box Search String Generator Excel Macro Workbook which helps in the generation of a List box search string. Please find the attached QlikView List Box Search String Generator Excel Macro.zip which contains the Excel Macro workbook, QlikView List Box Search String Generator.xlsm. Please see page 19 in the attached User Guide for more information on how to use this Excel Macro feature.
1. The QlikView Data Analyzer can be used for Rapid Application development, testing and validation purposes. Also its very much helpful for requirements gathering phase, for example you can quickly load the required tables and prepare the data model and have a WebEx session / In person session with the End Users and Business Analysts to quickly show them the Data, generate the expressions, show the expression results and also generate Charts and get feedback on further improvements and help with finalising / refining the requirements.
2. This Application can also be used to help building Qlik Sense applications by generating the Expressions quickly, copying and pasting into Qlik Sense Charts and also for Data validation and testing purposes. For this in order to work QlikView Data Analyzer Application should have the same Data Model as Qlik Sense Application.
1. This application has basic Set Analysis features and more advanced features like Set Operators, P() and E() functions are not included yet. Also Date ranges and Variables are not yet implemented in the Set Analysis expression generation. However even without these, its still very helpful to generate the expression quickly, copy into a Text object and manually enhance it as needed.
2. Also the Charts Generator is only implemented for generating Eight Chart types as you can see in the screenshot above. Also for Scatter chart a second expression need to be added manually to make it work.
Deploying into UAT / Production Environments
Once your application was built and ready to be deployed into UAT / Production environments then please see Page 17 of the attached User Guide document for the clean up process.
Please share your valuable feedback in the comments section to improvise the QlikView Data Analyzer features and functionality.