I have been trying to find some visualisation of QlikSense Tasks as a Gantt waterfall and tried working on the Ops Monitor app to add these. I finally chose to go sideways and make a mix between a 'QMC Sense Tasks Gantt-Waterfall' and a previously developed 'QVD Analyser' so that I could look at the full flow from Task > App > QVD files, tables and fields.
Special thanks to bill.markham for his comprehensive feedback and editing and improving this script/app to its final stage.
Special thanks to hic for sharing his folder analyser script.
Special thanks to Kai Hilton-Jones, whose GitHub - kaihj/qlik-sense-timeline: Qlik Sense Timeline Chart chart you need to install as an extension to view the Tasks Gantt Waterfall. You then need to configure this chart with:
- Task Name (sorted by Expression: "MaxString([Reload Start Time])")
- Reload Start
- Reload Finish
On the "Task Set Sequence Number", choose one of the higher value to see only one days worth of reloads (a 24 hour set). I have set the back-end code so that the sequence takes all tasks after COB (post 18h00) and groups them with the tasks running until next COB (so that all overnight loads are grouped). Please change the code if you want a different time horizon.
4 things need to be changed in the script:
- Binary load: Point to your own Ops Monitor (do not include ".qvf" extension if running this app on the server directly). You will need to create a LIB connection to the Apps folder where the original Ops Mon is stored. (Or use an INCLUDE function to attached "OpsMonScript.txt" file).
- The "vQMC_QVD_Store" variable: It should point to a LIBRARY folder where you would like to STORE (and load from) the QVDs from the Ops Monitor data model from the above BINARY load.
- Edit the "Full_Paths_To_Folder" table so that you have a full list of LIBRARY connections to where you STORE all QVDs for which you would like to collect their XML Header info for further visibility and analysis.
- (Optional) Setting the server name in variable "vQlikSenseServer" allows you to open the relevant app via URL hyperlink.
IMPORTANT NOTE: Due to the potential pervasiveness of script variable values in some Sense scripts which would end up in script errors, I include another file with the script of this app. I could be that you would require to copy/paste elements into a new/fresh file in order to allow the script to "clear out" and start with a new variable value.
Hope this helps.