Skip to main content Skip to complementary content

Analyzing impact analysis for apps, scripts, and datasets

Impact analysis shows the forward-looking, downstream view of a database, app, or field dependencies. It answers questions about which databases, apps, files, links, and other resources would directly or indirectly be impacted if the value of a field changes. You can also drill down to the particular fields that are impacted by the change.

Qlik Cloud provides an aggregated summary of downstream impact where you can interactively examine direct and indirect dependencies of a given field or object.

Downstream lineage is called impact analysis because it analyzes which objects will be impacted by changes to your data or application; these objects are the dependents of the base node. Qlik Cloud provides information and counts by type of dependent objects in a summary view.

Business users examining a given field will have an aggregated summary of downstream impact that delivers insight into:

  • Which object types would be impacted by a change to this field including databases, file storage, apps, and links
  • Which Power BI reports and dashboards would be impacted
  • Which Qlik NPrinting reports would be impacted
  • Which data models for Power BI and Tableau would be impacted
  • What is the number of direct dependencies and indirect dependencies by type
  • Who are the owners of the items that are impacted if you make a change

To view upstream lineage information such as inputs, transformations, and other historical information that can explain where your data came from and what operations have acted upon it, view its lineage. See Analyzing lineage for apps, scripts, and datasets

Impact analysis grid columns

Select columns of interest with the column-picker icon columns in the top-right of the grid. Column options vary depending on the type of resource being viewed. The column options may include the following headings: Name, Number of datasets | tables | fields, Type, Space, Owner, Last reload (apps), Last modified (other resources), Actions.

Impact analysis grid

Information noteWhen Owner and Space columns have multiple values, a tool-tip appears listing the owners and spaces.

Impact analysis summary view

Open impact analysis by selecting on an app or dataset tile or row depending on your view, and then selecting Impact analysis. You can also access an impact analysis summary view from the overview of a dataset by selecting and then selecting Impact analysis. You can access lineage (upstream) or impact analysis (downstream) for other nodes that appear in graphs by selecting and then selecting Lineage (Use as new base node) or Impact analysis.

In the summary view, you can filter on whether to display all or only direct dependencies. An example of a direct dependency is an app Application A that loads a particular dataset Datafile B. In this case, Application A directly depends upon Datafile B. An example of an indirect dependency is a QVD C.qvd that is created by Application A, based on Datafile B. In this case, C.qvd is an indirect dependency of Datafile B.

Impact analysis summary view shows dependent fields in an app

Impact analysis summary view showing dependent fields in an app

The base node being analyzed is outlined in blue. The dependents are listed in the left-hand overview with counts per type. When in focus and listed in the main grid, that type is outlined in a green box. Types of dependencies include databases, apps, file storage, databases, and links. The listed dependent objects for that type are listed in the main grid. Drill into these objects by selecting the row. For example, an app will drill down into table and then field-level.

To investigate impact of a field change, drill down from the base node object and select a field of interest to see dependencies for that field.

Drill in to base node to view and select field to focus on that field
  • Details (see Node details)

  • Make this the base node

  • Go to lineage (for that object)

  • Open to view the metadata Overview for that object. See Dataset overview

Select on the row of the dependent object in focus to access a menu with the following actions:

Actions that can be taken on dependent objects in impact analysis summary view

Actions menu in depenedencies grid

Node details

Details are limited by your access to that object. Details can provide the following information:

  • Name

  • Description

  • Tags

  • Location

  • Space

  • Owner

  • Creator

  • Last modified

Details view accessed from Impact analysis summary view

Details view from Impact analysis summary link


Users without view permission will not be able to view dependent resource names, the Last reload column for dependent apps or the Last modified column for other resource types. Users without view permissions will also not be able to view the context menu or drill-in options for the resource.

Example use case for analyzing impact analysis

For a walk-through of the following example, see:

Impact analysis use cases

Example: Understanding the impact of making a change to a dataset

As an app developer, you are responsible for a data source and are considering making a change to a dataset Sales data.xlsx by removing the field Price. The questions you have are: What will be impacted by making this change? What needs to be addressed? Who should I notify? You begin the investigation by selecting on the dataset tile and selecting Impact analysis.

Impact analysis summary view for the dataset Sales data.xlsx

View downstream dependencies for apps and datasets with impact analysis summary view

The impact analysis summary indicates that this dataset has 5 dependencies: the dataset is used in 4 apps (6 tables total) and 1 file storage (2 QVDs). The QVDs in the file storage are indirect dependencies because they are generated from the apps that were loaded with the base node Sales data.xlsx. Expand the base node Sales data.xlsx which opens a list of fields and select the field Price , now making Price the base node to be analyzed for impact analysis. The listed dependencies decrease resulting in a total of 3 apps that would be affected by a change to the field Price.

The following needs to be addressed:

  1. The dataset Sales data.xlsx should be reloaded when the field Price is removed.
  2. The owners of the dependent apps Sales analysis and Extract should be contacted so that they know to reload the dataset to their app. Locate the owner from the column Owner or select to open the context menu on the rows of both dependent apps Sales analysis and Extract; select Details to list the owner of the app.
  3. The owner of the impacted apps should be contacted and informed that their apps should be reloaded with the modified Sales data.xlsx dataset.

Select Details to determine the owners of impacted apps that should be reloaded with modified datasets

Open details to list the owner of the dependent object


Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!