Qlik Community

QlikView Documents

Documents for QlikView related information.

QlikView Task Analysis

Partner
Partner

QlikView Task Analysis

task analysis screen grab.PNG

Overview

For those of us that work with QlikView distribution service, either the standard version or Publisher then perhaps this model may be of some use in analysis of your tasks.

As a Qlik partner, I developed this to read in the various .xml files created by the distribution service and help look for some common problems such as:

  • repetitive failures (TASKS and RELIABILITY - top left and middle charts)
  • broken tasks  / missing files (ISSUES - top right)
  • resource contention (TASK EXECUTION - main chart)

There are lots of clever ways of analysing the QVPR data, including through the Governance dashboard, however I went with this approach as it gave me something tangible and reasonably simple to interpret and then present to a client.

Instructions

  1. Open the model in QlikView (preferably on the QlikView server)
  2. Navigate to the Configuration tab
  3. Update the file locations
  4. Click the Reload button
  5. Select the Dashboard tab and start your analysis

Considerations

  • Tasks with multiple short reloads may not be easily visible in the gantt chart
  • The Gantt chart works best with a single day selected
  • Colour conventions are red is bad, green is good and orange is a warning.

I have used in a mix of QlikView 11 and 12 environments using both Publisher and the standard distribution service though I can't account for all environments so the model is provided as is where is, though please feel free to expand for your own use or provide some feedback that may benefit the community.

Thanks for taking the time to read this and I hope you find it useful.

Attachments
Comments

I got it up and running really fast. The only things I needed to patch in the load script were the values for the DateFormat and TimestampFormat variables.

You may want to add those to your Configuration page.

BTW works like a charm. Thanks!

Partner
Partner

Hi Peter,

Thank you for the feedback - much appreciated.

I have updated the model with your suggestions as well as correcting a minor issue with the Gantt chart axes.

Kind regards,

Rod

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2018-05-08 08:14 AM
Updated by: