Application Checklist

     The Application Checklist is intended to be a best practices checklist for a single Qlik Sense application. It requires a number of inputs from the user, e.g. disk size, number of tables, number of rows, etc. If all of the input fields have been filled and the completed boxes have been checked, a report may be generated. This report is a pdf that will simply log all of the data that you entered with some scoring. The scoring is a sum of the boxes checked in total and per category – if all boxes are checked, the maximum score will be received. At this point in time there is no additional intelligence derived by any of the field inputs. The intent of the report is that it can be shared either internally or externally (with Qlik, for example) to help others know what has been done with the application, and know the high level metadata around it. This report could be used to help diagnose an issue, or simply just used as a best practices checklist. It could also be used internally as part of a workflow process to ensure an application has gone through the necessary optimization steps before entering production.


Application Name:

Application Disk Size (MB):

Application Size in RAM (GB):

Application Complexity:

Application Total Rows (M):

Application Total Fields:

Application Total Tables:

Data Model Performance

Indicators that could impact data model performance. Check each that has been followed for this application.

Interface Performance

Indicators that could impact the performance on the front-end. Check each that has been followed for this application.

Application Metadata Analyzer

About the Endpoint

     As of the Qlik Sense June 2018 release, a new application level metadata endpoint is available via the Qlik Sense Proxy (exposed via the Engine). Data is populated for this endpoint post-reload in a June 2018+ environment. From this data, a Qlik application has been built that ingests it and provides lightweight dashboard to analyze your applications. The URL to access this data is from a single application is


where server is a server that the application can be accessed over and GUID is the application ID. Note that the application does not need to be lifted into RAM for the metadata to be accessed.

Data from this endpoint includes:
  • server metadata including number of cores, total RAM
  • reload time
  • app RAM base footprint
  • field metadata including cardinality, tags, total count
  • table metadata including fields, rows, key fields

Example output from that endpoint can be seen here.

Application Metadata Analyzer App

The Application Metadata Analyzer is a Qlik Sense application that collates the metadata from every application on your server to give you a single app view of your application metadata along with additional data from the QRS API. Adding this additional data allows us to visualize who owns what applications, are they published or private, what nodes are they available on, etc. That application can be found here, and is shipped with Qlik Sense Enterprise on Windows as of the September 2019 release:

Data Connection Analyzer


The Qlik Sense Data Connection Analyzer is a Qlik application that parses script log files and queries the QRS API, allowing analysis of data connection usage, patterns, age, and cleanliness across a Qlik Sense site. In short, this app will help to run a leaner, more performant, and more easily and holistically governed Qlik Sense site.

The application is supported by Qlik's Americas Enterprise Architecture team, and uses only native connections and capabilities of the Qlik platform—making it plug-and-play.

The application can be found on GitHub here:

Common Questions & Associated Benefits of the App

  1. Which connections are no longer used? (A data connection is found in a script log and exists in the Qlik Sense site, however no associated applications currently exist that at one point had used it).
    • Removing unused connections will increase performance across a site, as less connections will have to be evaluated in security rule evaluations. If a site has hundreds or thousands of connections, this calculation time can build up.
    • Removing unused connections makes general administration easier, as there is less to manage.

  2. What connections have never been used? (A data connection exists in the Qlik Sense site, but no reference exists to it in any script log.)
    • It is common that users will create data connections to test connectivity, but then never actually use them. By leveraging this app, one can identify connections that have never been used and have existed for x amount of time (say 90+ days), so that action can be taken to remove them. The benefits from both simpler management and performance are listed in the bullet above. What connections have been deleted that used to be used? (A data connection that is found in script logs, but no longer exists in the Qlik Sense site and no app is using it.)

  3. What connections have been deleted that used to be used? (A data connection that is found in script logs, but no longer exists in the Qlik Sense site and no app is using it.)
    • By parsing the script logs, one can visualize old data connection names/paths that can help to serve as an audit trail.

  4. What are the most widely used data connections?
    • Depending on how this application is deployed, whether it be strictly administrative or potentially visible to developers, this metric is important both administratively and socially throughout the organization.

  5. Do we have duplicate data connections?
    • By analyzing the connection strings, one can tackle duplicate connections to the same source data. This eases administration overhead and will ensure that there is reusability/consistency across the platform.

  6. Who owns what data connections?
    • This is valuable from an access/security perspective to ensure governance of data sources.

  7. Who is using what data connections?
    • While "User A" might own "Data Connection A", "User B" might also have read access to that data connection. This can of course be visualized through the audit capability of the QMC, however this application will physically reveal who is executing any reloads of those data connections, giving greater visibility and allowing a deeper level of auditing and governance.

  8. Where are data connections being used?
    • Let's say a data source is being transformed and will be moved from one database to location. The first question one might ask is, "What applications are using that connection, so we can re-route it to the new db and make adjustments to the load scripts?". This historically has not been easy to answer. This application allows one to select that connection and visualize apps that are using it.

  9. Via what mechanism are data connections being used?
    • The application visualizes what connections are being run as tasks, manually, or in ODAG (or other API) requests. This is crucial in understanding user behavior.


Telemetry Dashboard for Qlik Sense

With the February 2018 of Qlik Sense, it is possible to capture granular usage metrics from the QIX in-memory engine based on configurable thresholds. This provides the ability to capture CPU and RAM utilization of individual chart objects, CPU and RAM utilization of reload tasks, and more.


  • Qlik Sense Enterprise February 2018 or later
  • Enable Telemetry Logging, instructions can be found on the wiki


  • All information (including installing, logging and uninstall) can be found the wiki page. The sidebar is used for navigation.

Download Latest Here

Qlik Sense Scalability Tools

This package (referred to as Qlik Sense Scalability Tool) contains a complete set of tools for easy creation, execution and analysis of load/performance tests.

Note: Using windows built-in unzip functionality will not allow the .exe to launch unless unblocking zipped packagefirst (properties -> unblock).

Included parts are:

  • Standalone application for creating and executing a simulation script
  • Documentation on how to use the package
  • Regression analyzer
  • Benchmarking package
  • App evaluator package

Qlik Sense documents to help analyze result and log files (previously included in this package) can be found here:

Download and other information:

Please refer to the Qlik Community page on Scalability Tools for the most recent download and ChangeLogs.

Your use of Qlik Sense Scalability Tool will be subject to the same license agreement between you and Qlik for your Qlik Sense License. Qlik does not provide maintenance and support services for the Qlik Sense Scalability Tool, however please check QlikCommunity for additional information on use of these products.

Scalability Tools with Qlik Sense YouTube Series


Qlik Fix

By Barry Harmsen

QlikView Addict

By Matt Fryer

Irregular BI

By Ralf Becher

BI Review

By Dmitry Gudkov

Living QlikView

By Aaron Couron

Learn All BI

By Chandraish Sinha

Qlik Dork

By Dalton Ruer

Unconventional QlikView

By Trey Bayne

Quick Intelligence

By Steve Dark

Natural Synergies

By Oleg Troyansky

By Stefan Walther

The Qlik Board

By Bill Lay

Harvesting Wisdom

By Karl Pover

Qlik Design Blog

By Qlik Staff

Qlik Branch

By Qlik Staff

Qlik Central

By Richard Pearce

QlikView Cookbook

By Rob Wunderlich


By George Beaton


By Stephen Redmond

BI Experience

By Juan Vitantonio

Qlik Freak

By Julian Villafuerte

Web of Work

By Adam Cooke


By Nick Webster